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..
Printable View
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. ;)
[COLOR="DarkOrchid"][I][B]Thanks...I tried it with the query which u gave...And itz working..
Thank u so much...[/B][/I][/COLOR]
[COLOR="Plum"]********************************[/COLOR]
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. ;)