SELECT * FROM student WHERE rollno = 10;
SELECT * FROM student WHERE name <> 'Anurag';
SELECT * FROM student WHERE name != 'Anurag';
SELECT * FROM student WHERE rollno > 1;
SELECT * FROM student WHERE rollno < 5;
SELECT * FROM student WHERE rollno >= 2;
SELECT * FROM student WHERE rollno <= 20;
SELECT * FROM student WHERE name like '%rag';
SELECT * FROM student WHERE rollno not like '%Kumar';
SELECT * FROM student WHERE rollno between 2 and 5;
SELECT * FROM student WHERE rollno not between 2 and 5;
SELECT * FROM student WHERE rollno in (2,5,10);
SELECT * FROM student WHERE rollno not in (2,5,10);
SELECT * FROM student WHERE batch is null;
SELECT * FROM student WHERE batch is not null;