Topic: SQL Query to get second highest salary-FAQ

Message


   SQL Query to get second highest salary-Frequently Asked Question in interviews
 
http://sqlqueriescollection.blogspot.com/2009/01/sql-query-to-retrieve-nth-highest.html

Author	Message
snigdha_123 Newbie Joined: 17Dec2007 Location: India Online Status: Offline Posts: 40	Topic: SQL Query to get second highest salary-FAQ Posted: 30Jan2009 at 12:00pm
	SQL Query to get second highest salary-Frequently Asked Question in interviews http://sqlqueriescollection.blogspot.com/2009/01/sql-query-to-retrieve-nth-highest.html
	http://www.funandknowledge.blogspot.com http://www.sqlqueriescollection.blogspot.com Post Resume: Click here to Upload your Resume & Apply for Jobs

	IP Logged

nidhinav Newbie Joined: 05Feb2009 Online Status: Offline Posts: 1	Posted: 05Feb2009 at 2:44am
	Select salary from salary ORDER BY salary DESC LIMIT 1,1
	IP Logged

skumar75.qa Newbie Joined: 18Sep2009 Online Status: Offline Posts: 16	Posted: 21Sep2009 at 12:51am
	Query for second highest Salary: select max(salary) from Employee where salary >(select max(Salary) from employee;
	IP Logged

skumar75.qa Newbie Joined: 18Sep2009 Online Status: Offline Posts: 16	Posted: 21Sep2009 at 12:52am
	Query for second highest Salary: select max(salary) from Employee where salary < (select max(Salary) from employee order by salary Edited by skumar75.qa - 30Sep2009 at 1:38am
	IP Logged


One Stop Testing Forum : Software Testing @ OneStopTesting : Beginners @ OneStopTesting