Internet Marketing Forum

For Webmasters and Entrepreneurs

Welcome, Guest. Please login or register.
Did you miss your activation email?
May 21, 2012, 03:06:48 PM

I start with the premise that the function of leadership is to produce more leaders, not more followers.

- Ralph Nader

Home

Privacy

Internet Marketing Forum > Online Business Discussions > Website Design and Maintenance > Database

Query for Third Highest Salary

0 Members and 1 Guest are viewing this topic.

Pages: [1]

Author

Topic: Query for Third Highest Salary (Read 211 times)

vikramrandhawa

Junior Member

Joined: Sep 2011
Posts: 71

$View vikramrandhawa\s Profile$
vikramrandhawa is from India

India

Sep 27, 2011, 02:35:51 AM

For Third Highest Salary from the employee table.

Select top1 salary from(select distinct top 2 salary from employee order by salary desc) a order by salary.

stock market tips,Bank nifty tips,option call | web design company,web hosting company

AceCoder

Junior Member

Joined: Oct 2007
Posts: 79

$View AceCoder\s Profile$

United States

Sep 27, 2011, 06:56:09 PM

not sure what you're asking here ? Can you please elaborate ?

Latest Blog Post : PHP – Pass by Reference or Pass by Value

AceCoder's Programming Tips

Summer Savings! $7.49 .com domains at GoDaddy.com!

Pages: [1]