Top MySQL Query for Experienced
12 Aug 2024
|
474 views
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.
๐ข Join Our WhatsApp Channel
Get Daily GK, Current Affairs, Amazing Facts & Quiz Updates.
๐ Join NowShare this Post
About Author
Quizer Team
Comments
Leave a Comment
Your email address will not be published. Required fields are marked *