Re: how to get the Nth record of a result ?

2003-01-27 Thread Alec . Cawley
> I'm trying to get the Nth record of a query which i don't know nothing > but the table name. > I mean something like select * from table where . "give > me the Nth result"; SELECT * FROM table LIMIT N,1 ; Alec --

Re: how to get the Nth record of a result ?

2003-01-27 Thread Gelu Gogancea
Hi, select * from table where LIMIT HOW_MANY_RESULT_YOU_WISH; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "

RE: how to get the Nth record of a result ?

2003-01-27 Thread daniel
will a LIMIT start,end work ? >= Original Message From alx <[EMAIL PROTECTED]> = >HI all >I'm trying to get the Nth record of a query which i don't know nothing >but the table name. > >I mean something like select * from table where . "give >me the Nth result"; > >I hope someone can he

Re: how to get the Nth record of a result ?

2003-01-27 Thread Joseph Bueno
Hi, select * from table where LIMIT N,1 More details at: http://www.mysql.com/doc/en/SELECT.html Regards, Joseph Bueno alx wrote: HI all I'm trying to get the Nth record of a query which i don't know nothing but the table name. I mean something like select * from table where . "give me th