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. Wri
Mithun Ashok's Experience, Summary, Trainings and Knowledge Sharing on Oracle Database, Oracle Applications, Fusion Middleware, SQL, PL/SQL and Database Testing
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