- Forum
- Databases
- MySQL using (top) along with select stmt is possible in MySQL???
-
Junior Member
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..
-
Junior Member
Re: using (top) along with select stmt is possible 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.
-
Junior Member
Re: using (top) along with select stmt is possible in MySQL???
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules