EMP
      
      

      
ID      
      
Name    
      
Country 
      
Salary 
      
      

      
1
      
Vijay
      
India
      
6000
      
      

      
2
      
Bill
      
USA
      
8000
      
      

      
3
      
Kris
      
France
      
3000
      
      
    

      
 ---- to delete all Rows 
      DELETE EMP

      
 ---- to delete specific Rows 
      DELETE EMP WHERE ID = 3


      
 ---- Difference between Drop, Delete, Truncate Tables 

      Drop Table:     Deletes Table Structure and Data
      Delete Table:   Deletes ALL Data without WHERE clause, Deletes some Data with WHERE clause
      Truncate Table: Deletes ALL Data, we can’t use WHERE clause