how to get the Nth record of a result ?

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 condition . give me the Nth result; I hope someone can help me. TIA Bye Alx

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

Hi, select * from table where condition 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

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

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 condition . give me the Nth result; I hope someone can help

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

Hi, select * from table where condition LIMIT HOW_MANY_RESULT_YOU_WISH; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message

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

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 condition . give me the Nth result; SELECT * FROM table LIMIT N,1 ; Alec