Page 102 - Computer Software Application TP - Volume 1
P. 102

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
   97   98   99   100   101   102   103   104   105   106   107