Member Avatar for sivak

can any one tell me how to write the query to find out first 6 highest salary from table
note: not 6 th highest salary ....

  • 3 Contributors
  • 5 Replies
  • 110 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by james_zheng
Member Avatar for james_zheng

select top 6 * from table_name order by salary asc

Member Avatar for dickersonka

actually it needs to be descending or else you will get bottom to top

select top 6 * from table_name order by salary desc
Member Avatar for james_zheng

he only need to find out first 6 highest salary, but no requrement for any sort on these 6 highest salary...

Member Avatar for dickersonka

he said the 6 highest salaries, if you do an asc sort, you will get the 6 lowest salaries, not highest

Member Avatar for james_zheng

oh! sorry for my misunderstanding:)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.