SUB Queries:
1. List the employees working in research department 2. List employees who are located in New York and Chicago
3. Display the department name in which ANALYSTS are working
4. Display employees who are reporting to JONES
5. Display all the employees who are reporting to Jones Manager
6. Display all the managers in SALES and ACCOUNTING department
7. Display all the employee names in Research and Sales Department who are having at least 1 person reporting to them
8. Display all employees who do not have any reportees
9. List employees who are having at least 2 reporting
10. List the department names which are having more than 5 employees
11. List department name having at-least 3 salesman
12. List employees from research and accounting having at-least 2 reporting
13. Display second max salary
14. Display 4th max salary
15. Display 5th max salary -- Answer for nth Max Salary
Co-Related Subqueries:
16. Write a query to get 4th max salary from EMP table
17. Write a query to get 2nd…
1. List the employees working in research department 2. List employees who are located in New York and Chicago
3. Display the department name in which ANALYSTS are working
4. Display employees who are reporting to JONES
5. Display all the employees who are reporting to Jones Manager
6. Display all the managers in SALES and ACCOUNTING department
7. Display all the employee names in Research and Sales Department who are having at least 1 person reporting to them
8. Display all employees who do not have any reportees
9. List employees who are having at least 2 reporting
10. List the department names which are having more than 5 employees
11. List department name having at-least 3 salesman
12. List employees from research and accounting having at-least 2 reporting
13. Display second max salary
14. Display 4th max salary
15. Display 5th max salary -- Answer for nth Max Salary
Co-Related Subqueries:
16. Write a query to get 4th max salary from EMP table
17. Write a query to get 2nd…
Comments
Why we use @@ symbol in oracle
or difference between @ and @@
Why we use @@ symbol in oracle
or difference between @ and @@ ?
Please change the back ground color of the site from black to whit and letter color to white so the site is more eye catching.
Refer to the link below for the difference,
Difference between @ and @@
Problem with white text is its too flashy, so I usually use them for sql statements or to highlight some text on my site.
Nevertheless will change my sites theme completely in some time. :-)
Regards,
Mithun
imbued
god has taught music sweet to the speechless birds
and god has sent mithun to teach sql
your teaching is multicolored,multifaceted flashing different hues
your teaching is like beacon light that is guiding students to their goal
your teaching has made a mark on everybodys heart
and people in large number enjoy your teaching
immortal are the merits of your teaching