SQL Tutorial

21 / 68

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.


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

Loading comments...