Forums
Database
MySQL
Select the top N ro...
 
Notifications
Clear all

Select the top N rows from a table  

    Last Post
   RSS

1
14/12/2019 11:45 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 mysql top n rows
1 Answer
1
14/12/2019 11:57 am

In MySQL we can accomplish this using the LIMIT key word in the query

for example:

Select * From employee order by salary desc LIMIT 25; --> This 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 (3), mysql (1), top n rows (3),
Share:
Share this
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •