Select top N rows f...
 
Notifications
Clear all

Select top N rows from a table  

   RSS

1

I have an employee table and I want to select the top 25 highest paid employees. How can I do that?

1 Answer
1

In SQL Server you can do this using the TOP keyword.

For example:

Select TOP 25 * from employee order by salary desc; 

The above query will return the TOP 25 highest paid employee details.

Share:
Share this
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •