Top MySQL Query for Experienced

IT & Software

12 Aug 2024 | 422 views

1. Write an SQL query to fetch all the Employees who are also managers from the EmployeeDetails table.
2. Write an SQL query to fetch duplicate records from EmployeeDetails (without considering the primary key – EmpId).
3. Write an SQL query to remove duplicates from a table without using a temporary table.
4. Write an SQL query to fetch only odd rows from the table.
5. Write an SQL query to fetch only even rows from the table.
6. Write an SQL query to create a new table with data and structure copied from another table.
7. Write an SQL query to create an empty table with the same structure as some other table.
8. Write an SQL query to fetch top n records.
9. Write an SQL query to find the nth highest salary from a table.
10. Write SQL query to find the 3rd highest salary from a table without using the TOP/limit keyword.