Pergunta de entrevista da empresa Coforge

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

Respostas da entrevista

Sigiloso

17 de mai. de 2022

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

Sigiloso

7 de set. de 2024

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