Updating a particular column in a subset:
Updating records can be done using the UPDATE and THE statement. The given example is illustrative of this:
UPDATE THE (SELECT students FROM faculty WHERE factno=1) nt
SET nt.studname = 'Modified' WHERE nt.studno = 11 and nt.sex = 'M' ;
Updates the record in the faculty 1 and under that the student 11 is updated.