Thread: How to find second max sal of employee with the co

View Single Post

  #8 (permalink)  
Old 05-16-2008, 04:08 AM
prajapati prajapati is offline
Junior Member
  
Join Date: May 2008
Posts: 1
prajapati is on a distinguished road
Send a message via AIM to prajapati Send a message via Skype™ to prajapati
For OpenSource Database MySQL
If We are Using MySQL the we can use Limit as :

SELECT <col name> FROM <table> order by <col name> DESC Limit (N-1), 1

Where,
N is integer eg. 3rd Max, 4th Max


Regards,
Pradeep Kumar Prajapati
Reply With Quote