121)
Delete those records from emp table whose deptno not available in dept table?
122)
Display those enames whose salary is out of grade available in salgrade table?
123)
Display employee name,sal,comm and whose netpay is greater than any othere in
the
company?
124)
Display name of those employees who are going to retire 31-Dec-99 if maximum
job period is
30 years?
125)
Display those employees whose salary is odd value?
126) Display those employees whose salary contains atleast 3
digits?
127)
Display those employees who joined in the company in the month of Dec?
128)
Display those employees whose name contains A?
129)
Display those employees whose deptno is available in salary?
130)
Display those employees whose first 2 characters from hiredate - last 2
characters sal?
131)
Display those employeess whose 10% of salary is equal to the year joining?
132)
Display those employees who are working in sales or research?
133)
Display the grade of jones?
134)
Display those employees who joined the company before 15th of the month?
135)
Display those employees who has joined before 15th of the month?
136)
Delete those records where no of employees in particular department is less
than 3?
137A) Delete those employeewho joined the company 10 years back
from today?
137B)
Display the deptname the number of characters of which is equal to no of
employee
in
any other department?
138)
Display the deptname where no employee is working?
139)
Display those employees who are working as manager?
140)
Count th number of employees who are working as managers (Using set opetrator)?
No comments:
Post a Comment