Answer Detail: RE: Find second lowest salary from emp table

GeekInterview.com > Interview Questions > Database > SQL

Print |

Question: Find second lowest salary from emp table

Answer: display the second lowest salary from emp table without using min & all

July 07, 2008 23:46:22	#9
anu1985	Member Since: May 2008 Total Comments: 11
RE: Find second lowest salary from emp table
select salary ,empname from emptable order by(salary) limit 1,1;