Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  re: wanting 3 highest earners only

Author  Topic  msa969 Starting Member 13 Posts Posted - 2001-11-12 : 21:30:07 Given an employer table: Employer empno |ename | salary | deptno How can I query to give me the results of the top 3 earners. i.e ename | sal ------ ----- James 50,000 Harry 60,000 Tom 90,000