SQL Tutorial : DML : DELETE

SQL Tutorial : DML : DELETE

Let's learn about next topic: DELETE

DELETE:

********

- used to delete the data from the table

- DELETE FROM SAMPLE

- DELETE FROM SAMPLE

WHERE EMPLOYEE_ID=119

- DELETE FROM EMPLOYEES

WHERE DEPARTMENT_ID=(SELECT DEPARTMENT_ID

 FROM EMPLOYEES

 WHERE EMPLOYEE_ID=110)

- DELETE FROM DEPARTMENTS

WHERE DEPARTMENT_ID=60

- INSERT INTO DEPARTMENTS

VALUES(345,INITCAP('SALES AND SERVICE') ,100,1700)