how to compare in sql

1-- Oracle
2
3-- Example
4SELECT * 
5FROM Table1 -- the table containing extra records
6  MINUS
7  SELECT * 
8  FROM Table2;
9
10-- Syntax 
11SELECT * 
12FROM <table-1> -- the table containing extra records
13  MINUS
14  SELECT * 
15  FROM <table-2>;

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;