Is there any alternative for ROWNUM and ROWID in mysql??

[bravo]

hi ,
i need to know whether there is any alternative method through which i can get the result of the querries like below in my sql...

select * from table_name where rownum=1 and rowid not in (select rowid from table_name where rownum<10)

thanks in adwance

[r035198x]

hi ,
i need to know whether there is any alternative method through which i can get the result of the querries like below in my sql...

select * from table_name where rownum=1 and rowid not in (select rowid from table_name where rownum<10)

thanks in adwance

That is not valid MySQL. In mysql you use limit to limit the number of rows returned. Is that what you are looking for or are you looking for oracle alternatives?

[debasisdas]

ROWNUM and ROWID are Oracle only terms.
These two are pseudo columns not supported in any other database.

[jcvlad]

Yes, ROWNUM and ROWID are Oracle only terms.
In MYSQL, use this one :

SELECT your_columns FROM your_table LIMIT 1 (or your rows number);