Flash Sale: Flat 70% + Addl. 25% Off on all Courses | Use Coupon DS25 in Checkout | Offer Expires In

  Enroll 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...