Like the UPDATE command, the DELETE command is also very simple to use. The following command deletes entries with the albumcode of 2002:
isql=>DELETE FROM music.albums WHERE albumcode = 2002; Return
