Diksha IT Training Centre

Important Queries in SQL Part 5. In my previous blogs I discussed about several SQL queries which commonly used in SQL and today again   I will discuss about some important queries in SQL . Before that I suggest you to go through my SQL and PL/SQL blogs in archive May and June folder for your understanding.   Also you can see my below previous blogs about Queries in SQL for your reference. https://dheeraj60.blogspot.com/2020/07/important-queries-in-sql-part1-dotcmdb.html https://dheeraj60.blogspot.com/2020/07/important-sql-queries-part-2-dotcmdb.html https://dheeraj60.blogspot.com/2020/07/important-queries-in-sql-part3-dotcmdb.html https://dheeraj60.blogspot.com/2020/07/important-queries-in-sql-part-4-dotcmdb.html 1.   Co- Related Sub Query Example : Let’s take an example for a typical correlated sub query. In this example, we need to find all employees whose salary is above average for their department. Below is the Query : SELECT emp_id, emp_name   FROM department dept   WHERE