This is a discussion on Select second max record.. within the MySQL Database forums, part of the Database Forums category; Hi Guys, I have a query in which I want to select the second maximum record from a table. Can ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
On Thu, 13 Sep 2007 04:48:59 -0000, Rahul <rahulazm@gmail.com> wrote:
>Hi Guys, > I have a query in which I want to select the second >maximum record from a table. > Can you please help me to get that..with the exact >query . >Thanks >Rahul S SELECT ... .... ORDER BY ... LIMIT 1,1 |