81)
Display the date three months before the Current date?
82)
Display the common jobs from department number 10 and 20?
83)
Display the jobs found in department 10 and 20 Eliminate duplicate jobs?
84)
Display the jobs which are unique to department 10?
85)
Display the details of those employees who do not have any person working under
him?
86)
Display the details of those employees who are in sales department and grade is
3?
87)
Display thoes who are not managers?
88)
Display those employees whose name contains not less than 4 characters?
89)
Display those department whose name start with"S" while location name
ends with "K"?
90)
Display those employees whose manager name is Jones?
91)
Display those employees whose salary is more than 3000 after giving 20%
increment?
92)
Display all employees with their department names?
93)
Display ename who are working in sales department?
94)
Display employee name,dept name,salary,and commission for those sal in between
2000 to
5000 while location is Chicago?
95)
Display those employees whose salary is greater than his managers salary?
96)
Display those employees who are working in the same dept where his manager is
work?
97)
Display those employees who are not working under any Manager?
98)
Display the grade and employees name for the deptno 10 or 30 but grade is not 4
while joined
the company before 31-DEC-82?
99) Update the salary of each employee by 10% increment who are
not eligible for commission?
100)
Delete those employees who joined the company before 31-Dec-82 while their
department Location is New York or Chicago?
No comments:
Post a Comment