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 <techie...@gmail.com>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 ilug-tvm@googlegroups.com > To unsubscribe from this group, send email to > ilug-tvm-unsubscr...@googlegroups.com > > > > 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 ilug-tvm@googlegroups.com To unsubscribe from this group, send email to ilug-tvm-unsubscr...@googlegroups.com For details visit the google group page: http://groups.google.com/group/ilug-tvm?hl=en