Deleting Individual Records:
Deletion can be done in two ways. Either the overall record gets deleted or the corresponding record in the subset can be deleted.
DELETE FROM THE (SELECT students FROM faculty WHERE factno = 1)nt# for deleting individual record#
WHERE nt.studno=11
That deletes the record corresponding to student 11 for the faculty number 1.