mysql equivalent for Select top 3 * From Table
-
Hi All, Can anybody suggest the mysql equivalent for the sql query Select top 3 * From Table Thanks in advance
-
Hi All, Can anybody suggest the mysql equivalent for the sql query Select top 3 * From Table Thanks in advance
Hi, try appending "LIMIT start, length" to your MySQL query. And Google "MySQL LIMIT". :)
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
-
Hi All, Can anybody suggest the mysql equivalent for the sql query Select top 3 * From Table Thanks in advance
you can use Select * From Table limit 0,3
-
you can use Select * From Table limit 0,3
SELECT * FROM tbl_name LIMIT 3;