Coforge Interview Question: 1. Write a query to find the 5th largest item in a table.

Notifications

Coforge

1. Write a query to find the 5th largest item in a table.

Anonymous

May 17, 2022

Select top 1 item from (Select top(5)item from table order by item desc)A order by item

Anonymous

Sep 7, 2024

SELECT salary FROM emp ORDER BY salary DESC LIMIT 1 OFFSET 4;