DEV Community

Muthu
Muthu

Posted on

2 3

[SQL] Find third largest record from a table

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)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay