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

June 06, 2008 06:06:05	#4
priiti_bangarwa26	Member Since: June 2008 Total Comments: 3
RE: Find second lowest salary from emp table
dont make simple queries the big ones,try to use as simple as possible:- select max(sal) from emp where sal<>(select max(sal) from emp )