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

Oldest comments (0)

Read next

franckpachot profile image

Data Residency Compliance: PostgreSQL RLS to access YugabyteDB local region

Franck Pachot -

avinashrepo profile image

#7 MongoDB VS SQL

avinash-repo -

anshul_kichara profile image

Simplifying Site-to-Site VPN Connectivity with StrongSwan

Anshul Kichara -

caldayapp profile image

Scheduling tool calday: Streamlining Your Daily Routine

Calday -