Just I wanna to retrieve only third maximum salary from that table On Sep 6, 7:02 pm, sunil s <sunils1...@gmail.com> wrote: > 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