Question

Jagriti wants to display the list of all the students in relation 'Student' with fields (Admno, Name, DOB, DOJ, City, Class, FatherName, MotherName) whose city name ends with letter 'd' in descending order of Admno. Identify the correct query to do the same from the following:

(a) Select * from Student where City like 'Ind' order by Admno;

(b) Select Student where City like '%d' order by Admno;

(c) Select *from Student where City like '%d' order by Admno desc;

(d) Select * from Student where City like '*d' order by Admno desc;

Answer 1

Correct option is (c) Select *from Student where City like '%d' order by Admno desc;