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

welel profile image

Best Practices for Alembic and SQLAlchemy

Pavel Loginov -

grayhat profile image

LuxDevHQ (Lux Academy and Data Science East Africa) Training Program in AI, Data Science, Analytics, and Data Engineering

Mwenda Harun Mbaabu -

intalink profile image

IntaLink: A New NL2SQL Technology Distinct from Large Models

intalink -

franckpachot profile image

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

Franck Pachot -