Select the top N ro...
 
Notifications
Clear all

Select the 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?

Topic Tags
1 Answer
1

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.

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