from the table display the 2nd highest salary? and also the least 2nd sala

ALLInterview.com :: Home Page

KalAajKal.com

Advertise your Business Here

Browse | Placement Papers | Company | Code Snippets | Certifications | Visa Questions

Post Question | Post Answer | My Panel | Search | Articles | Topics | ERRORS ^new

Refer this Site

Contact Us

Login | Sign Up


	Ask Questions on ANYTHING, that arise in your Daily Life at FORUM9.COM

Google

Categories >> Software >> Databases >> SQL-Server

Question	from the table display the 2nd highest salary? and also the least 2nd salay?
Question Submitted By :: Om Namo Bhagavathe Vasudevaya
I also faced this Question!!		Rank	Answer Posted By

Answer	SELECT 'Second Highest Salary Is ', MAX(Salary) FROM Employee WHere Salary < ( Select MAX(Salary) FROM Employee ) SELECT 'Second Least Salary Is ',MIN(Salary) FROM Employee WHere Salary > ( Select MIN(Salary) FROM Employee )	0	Soorai Ganesh

View All Answers


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com