SQL Tutorial

21 / 68
Previous Index Next  

Deleting data from a table

  • One or more rows of a table can be deleted with 'delete' command to get rid of the data which is no more needed.
  • Delete operation will reduce the number of rows in the table which may help in faster select/insert/update on the table.

Syntax:

delete from table_name [where clause]

delete from deptt
where depstreet = 'Laker Street'
;
select * from deptt;

No hints are availble for this assesment

Answer is not availble for this assesment

Previous Index Next  
Please login to comment

0 Comments

There are 4 new comments.