Wednesday 9 October 2013

05. The EmployeeDetails table contains the records of the employees. Write a query to delete the records of those employees who are designated as clerk. In addition, ensure that all the deleted rows are displayed after the execution of the query.

Delete EmployeeDetails output
deleted.*Where Designation='Clerk'

No comments:

Post a Comment