can we use as like as rownum in mysql or not????/

[senthil kumar]

hi

i need to use rownum in my prj. so let me know that
can we use as like rownum in mysql or not.

if not what can we use instdead of mysql

limit doeSnt work for me

I NED TO USE ROWNUM IN THE SELECT LIST, SO GIVE ME AN IDEA TO SELECT FIRST N NUMBER OF ROWS

thankx in advance

senthil