Page 102 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

TASK 3 :Using delete query:
Delete Query: to remove rows from tables
DELETE FROM your table name
WHERE condition;

EX - DELETE FROM employee
WHERE first name = ‘Abigail’;

For show the records

SELECT * FROM employee;

The return value here indicates that the DELETE command was processed with a single row being removed.
Using DELETE to remove multiple rows at once

87
CITS : IT & ITES - Computer Software Application - Exercise 27 CITS : IT & ITES - Computer Software Application - Exercise 27