Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to find nth highest salary

Answer Posted / parmesh m

select top 1 salary from Employee where salary in (
select top n salary from Employee
group by salary
having count(salary )< n+1
order by salary desc )
order by salary

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is @@error in sql?

1106


What is oltp (online transaction processing)?

1057


What is a dbms wizard?

1074


What is rs.exe utility?

162


What is the stuff and how does it differ from the replace function?

1224


Is null in sql server?

1041


How to concatenate two character strings together?

1166


What is bit data type?

1081


What is table join?

1170


Describe the left outer join & right outer join. : sql server database administration

1036


How to verify a login name with sqlcmd tool?

1263


What are the new scripting capabilities of ssms? : sql server management studio

1118


What are the differences between char and nchar in ms sql server?

1140


What is the purpose of the model database?

1065


Can we linked SharePoint to a SQL database?

1073