Thread: using (top) along with select stmt is possible in MySQL???

Is it possible to use this query
select top 5 * from tablename;
to get the top 5 rows frm a table in MySQL???Actuallt in SQL i tired it n itz wrking...But itz giving error in MySQL..

In MySql if u want the first n rows then try this one

select * from table_name limit 0,n;

I haven't tried it. Hope this will work.

Thanks...I tried it with the query which u gave...And itz working..
Thank u so much...
********************************
In MySql if u want the first n rows then try this one

select * from table_name limit 0,n;

I haven't tried it. Hope this will work.