Delete those department where no employee working delete from dept d where

Delete those department where no employee working

This preview shows page 10 - 12 out of 17 pages.

119.Delete those department where no employee working? 121.Display those earners whose salary is out of the grade available in Sal grade table? 122.Display employee name, Sal, comm. and whose net pay is greater than any other in the company? 123.Display name of those employees who are going to retire 31-dec-99. If the maximum job is period is 18 years? 124.Display those employees whose salary is ODD value? 125.Display those employees whose salary contains at least 4 digits? 126.Display those employees who joined in the company in the month of DEC? 127.Display those employees whose name contains “A”? 129.Display those employees whose first 2 characters from hire date-last 2 characters of salary? 130.Display those employees whose 10% of salary is equal to the year of joining? 131.Display those employees who are working in sales or research? 132.Display the grade of Jones?
Image of page 10
133.Display those employees who joined the company before 15thof the month? 134.Delete those records where no of employee in a particular department is less than 3? 135.Delete those employees who joined the company 21 years back from today?
Image of page 11
Image of page 12

You've reached the end of your free preview.

Want to read all 17 pages?

  • Spring '18
  • emp, SELECT MAX, Display Name

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture