Forums
Database
MS SQL Server
Select top N rows f...
 
Notifications
Clear all

Select top N rows from a table  

    Last Post
   RSS

1
14/12/2019 11:50 am

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

chapr89
chapr89 
(@chapr89)
Eminent Member
| 21 Posts
20 3 0
Add a comment
Topic Tags
sql server sql top n rows
1 Answer
1
14/12/2019 12:02 pm

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.

Raja
Raja 
(@ambitechsolutions)
Member Admin
| 16 Posts
0 16 0
Add a comment
Topic Tags:  sql server (1), sql (3), top n rows (3),
Share:
Share this
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •