Thread
:
i want to get the third highest salary from a table?
View Single Post
#
6
(
permalink
)
12-27-2006, 01:39 AM
GasGiant
Posts: n/a
MySQL
answer.
Re: i want to get the third highest salary from a table?
[sql]
SELECT Emp_id, Emp_salary
FROM employees
ORDER BY Emp_salary
LIMIT 2, 1;
[/sql]
GasGiant
MySQL