You mean both answer in a single query? Otherwise select * from table order by salary limit 5
On Mon, Sep 6, 2010 at 5:14 PM, Gowthaman Basuvaraj <[email protected]>wrote: > > > >> Any one do you know that how to find maximum five salaries >> from a salary table in MySql >> and How to find the third maximum salary in that table? >> please let you explain >> >> > Refer manual, refer to Order by and limit > > > > -- > "Freedom is the only law". > "Freedom Unplugged" > http://www.ilug-tvm.org > > You received this message because you are subscribed to the Google > Groups "ilug-tvm" group. > To control your subscription visit > http://groups.google.co.in/group/ilug-tvm/subscribe > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > > > > For details visit the google group page: > http://groups.google.com/group/ilug-tvm?hl=en > -- "Freedom is the only law". "Freedom Unplugged" http://www.ilug-tvm.org You received this message because you are subscribed to the Google Groups "ilug-tvm" group. To control your subscription visit http://groups.google.co.in/group/ilug-tvm/subscribe To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For details visit the google group page: http://groups.google.com/group/ilug-tvm?hl=en
