Sql running multiple queries

Question

Here is my code to fetch 2nd highest salary in a company...

select salary from org order by salary desc limit(1,1)

above result will be one row ...with highest salary(100000) ,,,now i want to fetch all employes emp_names with the second highest salary.. how to do that?

PinnyM · Accepted Answer · 2013-01-07T22:17:39.900

3

Add DISTINCT to your query (in case multiple people have the same highest salary), and join it like this:

select org.* from org
join (select distinct salary from org order by salary desc limit(1,1)) org_salary
  on org.salary = org_salary.salary

Working sqlfiddle here

edited Jan 07 '13 at 22:17

answered Jan 07 '13 at 22:02

PinnyM

35,165
3
73
81

`LIMIT` is not supported inside an `IN ()` subquery. This will error. – Michael Berkowski Jan 07 '13 at 22:03
1

That answer doesn't use an `IN()` subquery, it uses a joined subquery where `LIMIT` _does_ work. – Michael Berkowski Jan 07 '13 at 22:05
just curious to know is there any other way..? – Friend Jan 07 '13 at 22:11
@user - sure, you could do it with two queries instead (one to get the salary, another to get all the employees with that salary) but not sure why you would want to. – Eric Petroelje Jan 07 '13 at 22:12
k in case if i use two queries.. how to give `where` condition? – Friend Jan 07 '13 at 22:15
pass it as a parameter - see http://stackoverflow.com/questions/60174/how-to-prevent-sql-injection-in-php – PinnyM Jan 07 '13 at 22:17

Sql running multiple queries

1 Answers1