Only Few Seats Left for Advanced Certification Courses on Data Science, ML & AI by E&ICT Academy IIT Roorkee

  Apply Now

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

Loading comments...