Select S1.Rno from Student S1 where S1.grade > ANY (Select S2.grade from Student S2 where S2.name like ‘C%’)
1
Retrieves students whose grade is not better than some students whose name starts with C.
2
Retrieves students whose grade is not better than any other student
3
Retrieves students whose grade is better than any other student
4
Retrieve students whose grade is better than some students whose name starts with C.