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.
Comments
Leave a Comment
Your email address will not be published. Required fields are marked *