Delete comment from: Java67
125. Display all employees with their department names
126. Display ename who are working in sales department
127. Display ENAME, DNAME, SAL and COMM for employees with salary between 2000 to 5000 and location is Chicago
128. Display those employees whose salary is greater than his managers salary
129. Display those employees who are working in the same dept where his manager is work
130. Display those employees who are not working under any Manager
131. Display ENAME, GRADE (deptno 10 or 30) (grade is not 4) (joined company before 31-DEC-82)
132. Delete employees joined company before 31-Dec-82 while their Location is New York or Chicago?
133. Display employee name ,job,deptname,loc for all who are working as manager?
134. Display those employees whose manager name is JONES and also display their manager name?
135. Display employee names who are working in ACCOUNTING department
136. Display the employee names who are working in CHICAGO
137. Display name and salary of FORD if his salary is equal to hisal of his grade?
138. Display employees whose salary is less than his manager but more than salary of other managers?
139. Display those employees whose manager name is Jones
140. Display the details of those employees who do not have any person working under him
141. Display the details of those employees who are in sales department and grade is 3
142. Display those department where no employee working?
143. Display ename, job and his manager. Display also employees who are without managers?
144. Find out the number of employees whose salary is greater than their managers salary?
145. Display ename, job, dname, his manager name, his grade and display output department number wise?
146. List ename, job, sal, grade and dname for everyone in a company except 'CLERK'. Sort on salary display the highest salary first?
147. Display ENAME, Manager Name for employees who has EMPNO as odd number; Display ENAME, Manager’s Manager Name for all the employees who has EMPNO as even number. If Manager’s Manager is not present display Manager Name and display employee name if no manager is present for that employee. Output should consist of two columns: 1-ENAME, 2-BOSS
Apr 4, 2017, 8:16:41 AM
Posted to Top 10 Frequently asked SQL Query Interview Questions Answers