Thread: to find top 10 salaries of employees with their names
View Single Post
  #2 (permalink)  
Old 04-30-2007, 01:37 PM
ben ben is offline
Administrator
  
Join Date: Mar 2007
Posts: 93
ben has disabled reputation
Default ANY answer. Re: to find top 10 salaries of employees with their names
Assume you have a table 'employees' with the fields 'salary' and 'name'

[sql]SELECT name, salary FROM employees ORDER BY salary DESC LIMIT 10[/sql]
Reply With Quote