Monday, 13 August 2012

Example for Update data in a table

Example:

Update FIRST_NAME to 'JOE' in STUDENT table for the student whose Id is 1 .

Query:

UPDATE STUDENT
SET FIRST_NAME = 'JOE'
WHERE STUDENT_ID =1


No comments:

Post a Comment