EMP
      
      

      
ID      
      
Name    
      
Country 
      
Salary 
      
      

      
1
      
Vijay
      
India
      
6000
      
      

      
2
      
Bill
      
USA
      
8000
      
      

      
3
      
Kris
      
France
      
3000
      
      
    

 ----  Low Performance by using IN 
      SELECT * FROM EMP
      WHERE ID IN (1,2,3,4,5)


      
 ----  High Performance by using BETWEEN 
      SELECT * FROM EMP
      WHERE ID BETWEEN 1 AND 5
      
      
 ----  both Queries will give the same output but Performance is different, if the data is tooooo big