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%'

priyadarshini

• Feb 10th, 2006

 

answer is

select * from students where city like 'was%'

Raghu

• Aug 3rd, 2006

 

Answer: D

Amandeep Kaur Dhawan

 Profile Answers by Amandeep Kaur Dhawan 

• Jan 12th, 2010

 

D. for match type queries we use like operator, and % stands for 1 or more characters.