John wants to retrieve all records from students table who live in any city beginning with WAS . Which of the following statement is to be executed by himA. Select * from students where city = 'WAS'B. Select * from students where city = 'WAS%'C. Select * from students where city in 'WAS'D. Select * from students where city like 'WAS%'

  • Interview Candidate
  • 4
  • 1750

Showing Answers 1 - 4 of 4 Answers

priyadarshini

  • Feb 10th, 2006
 

answer is

select * from students where city like 'was%'

  Was this answer useful?  Yes

Raghu

  • Aug 3rd, 2006
 

Answer: D

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions