sql server compare to value code example

Example 1: how to compare in sql

(Between) operator same as  ">= <="
For example: 
Select * From Employees Where salary Between 4000 AND 6000;

(NOT) operator excluding given
For example:
Select last_name, job_id From Employees
Where "Not" job_id = 'ABC';


(IN) operator in sql like "OR" operator
For example: 
Select * From employees
Where department_id "IN" (60,90); 


(Like) Operator for partial searches using wildcard '%' and '_'
For Example:
Select * From Employees
Where last_name LIKE '_a%';


(Top N results)
Select * From Employees Where ROWNUM <=5;


(NVL) replaces NULL values with same type default
value provided.
For Example = 
Select NVL(commission_percentage, 0)
From Employees;

Example 2: compare field sql server

SELECT 
  CASE WHEN COLUMN1 = COLUMN2 
    THEN '1' 
    ELSE '0' 
  END 
  AS MyDesiredResult
FROM Table1
INNER JOIN Table2 ON Table1.PrimaryKey = Table2.ForeignKey