DEV Community

Muthu
Muthu

Posted on

[SQL] Find third largest record from a table

#sql

Query to find third largest salary record from employee table

SELECT * 
FROM employee_info
ORDER BY salary
LIMIT 2, 1
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Read next

rick_wilson_3dc489f0f1860 profile image

Gmail tips and tricks pt: 2 Google Drive integration

Rick Wilson -

coinbuck_0bea50a5e99d37a7 profile image

Crypto Engagement and Passive Earning: A New Frontier in Digital Finance

coinbuck -

mayankpareek profile image

Increasing Code Coverage in faker-cxx

Mayank Kumar -

mahdavipanah profile image

Resolving MongoDB Error When Starting with Homebrew on macOS

Hamidreza Mahdavipanah -