Community

FETCH FIRST ROW ONLY in an update query?

(Craig Mullins) Can I use FETCH FIRST ROW ONLY in a select statement of update query? Example: (SELECT SCH.SCHEDULEID FROM ASHOK.INTERVIEWERSCHEDULEMASTER SCH, ASHOK.RESUMEDETAILS SSS WHERE SCH.INTERVIEWLOCATION =SSS.CANDIDATELOCATION AND SSS.SCHEDULEID IS NULL AND SSS.REQUIREMENTID IS NO

Read More - Register for Free Membership

Tags: