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

mrcaption49 profile image

B-tree index in ORACLE SQL

Pranav Bakare -

esproc_spl profile image

Getting members according to primary key values #eg63

Judy -

shikha_gupta_080e904b317e profile image

Handling Data in SQL: Signed vs. Unsigned Types

Shikha Gupta -

franckpachot profile image

SQL-92 in TPC Benchmarks: Are They Still Relevant?

Franck Pachot -