DEV Community

Muthu
Muthu

Posted on

[SQL] Find N'th largest record without LIMIT 

SELECT * 
FROM employee_info e1
WHERE N-1 = 
   (
      SELECT COUNT(DISTINCT salary)
      FROM employee_info e2
      WHERE e1.salary < e2.salary
    )
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Read next

oliviarizona88 profile image

Tailwind And CSS

oliviarizona -

neers profile image

Implement Circuit Breaker using Polly in .Net Core 8

Neer S -

romanmarshanski profile image

Custom GPTs: Revolutionizing Tech Integration

Roman Marshanski -

hannahanot profile image

TailwindCSS and Next.js

Hannah -