SQL Delete with Where

SQL Delete with Where clause will delete record which completes the condition

Take a table Student

StudentID StudentName StudentCity
1 Rahul Chandigarh
2 Karan Mohali
3 Neha Delhi
4 Manpreet Chandigarh
5 Ajay Delhi


Delete Query with WHERE




DELETE FROM Student WHERE StudentCity='Mohali';



Output

StudentID StudentName StudentCity
1 Rahul Chandigarh
3 Neha Delhi
4 Manpreet Chandigarh
5 Ajay Delhi

Back To Top