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

wallacemaxters profile image

Create a Laravel command to add your queue:work for a project as Systemd service in Linux

Wallace Maxters -

krinskumar profile image

Proper Contributions - 2

Krinskumar Vaghasia -

okpalan profile image

The 2x2 Testing Matrix & Branch Coverage: A Robust Approach to Automated Software Validation

Nnamdi Okpala -

danial profile image

Navigating Amazon Web Services: A Guide to Customer Care

Danial Ranjha -