comparison operators sql

1(Between) operator same as  ">= <="
2For example: 
3Select * From Employees Where salary Between 4000 AND 6000;
4
5(NOT) operator excluding given
6For example:
7Select last_name, job_id From Employees
8Where "Not" job_id = 'ABC';
9
10
11(IN) operator in sql like "OR" operator
12For example: 
13Select * From employees
14Where department_id "IN" (60,90); 
15
16
17(Like) Operator for partial searches using wildcard '%' and '_'
18For Example:
19Select * From Employees
20Where last_name LIKE '_a%';
21
22
23(Top N results)
24Select * From Employees Where ROWNUM <=5;
25
26
27(NVL) replaces NULL values with same type default
28value provided.
29For Example = 
30Select NVL(commission_percentage, 0)
31From Employees;
32

1(Between) operator same as  ">= <="
2For example: 
3Select * From Employees Where salary Between 4000 AND 6000;
4
5(NOT) operator excluding given
6For example:
7Select last_name, job_id From Employees
8Where "Not" job_id = 'ABC';
9
10
11(IN) operator in sql like "OR" operator
12For example: 
13Select * From employees
14Where department_id "IN" (60,90); 
15
16
17(Like) Operator for partial searches using wildcard '%' and '_'
18For Example:
19Select * From Employees
20Where last_name LIKE '_a%';
21
22
23(Top N results)
24Select * From Employees Where ROWNUM <=5;
25
26
27(NVL) replaces NULL values with same type default
28value provided.
29For Example = 
30Select NVL(commission_percentage, 0)
31From Employees;

1> Greater than
2< Less than
3>= Greater than or equal to
4<= Less than or equal to
5<> Not equal to