EMP
      
      

      
ID      
      
Name    
      
Country 
      
Salary 
      
      

      
1
      
Vijay
      
India
      
6000
      
      

      
2
      
Bill
      
USA
      
8000
      
      

      
3
      
Kris
      
France
      
3000
      
      
    

      Select * from EMP   WHERE   Name = 'Vijay'

      Select * from EMP   WHERE   (Name != 'Bill' and Country != 'France')

      Select * from EMP   WHERE   Salary BETWEEN 5000 and 7000

      Select * from EMP   WHERE   ID <= 1

      
 -- all above queries will give the same below output 

      

      
Output

      

      
ID
      
Name
      
Country
      
Salary
      

      

      

      
1
      
Vijay     
      
India     
      
6000