Ex:
SQL> select * from student where no = 2;
NO NAME MARKS
---
------- ---------
2
Saketh 200
2
Naren 400
SQL> select * from student where no < 2;
NO NAME MARKS
---
------- ----------
1
Sudha 100
1
Jagan 300
SQL> select * from student where no > 2;
NO NAME MARKS
---
------- ----------
3
Ramesh
4
Madhu
5
Visu
6
Rattu
SQL> select * from student where no <= 2;
NO NAME MARKS
---
------- ----------
1
Sudha 100
2
Saketh 200
1
Jagan 300
2
Naren 400
SQL> select * from student where no >= 2;
NO NAME MARKS
---
------- ---------
2
Saketh 200
2
Naren 400
3
Ramesh
4
Madhu
5
Visu
6
Rattu
SQL> select * from student where no != 2;
NO NAME MARKS
---
------- ----------
1
Sudha 100
1
Jagan 300
3
Ramesh
4
Madhu
5
Visu
6
Rattu
SQL> select * from student where no <> 2;
NO NAME MARKS
---
------- ----------
1
Sudha 100
1
Jagan 300
3
Ramesh
4
Madhu
5
Visu
6
Rattu
