Returning Top 5 Rows in MySQL

Q

How To Return Top 5 Rows in MySQL?

✍: FYIcenter.com

A

If you want the query to return only the first 5 rows, you can use the LIMIT clause, which takes one parameter as the maximum number of rows to return. The following statement returns the first 5 rows from the fyi_links:

mysql> SELECT id, url, counts, tag FROM fyi_links 
   ORDER BY counts DESC LIMIT 5;
+-----+-------------------+--------+------+
| id  | url               | counts | tag  |
+-----+-------------------+--------+------+
| 107 | www.winrunner.com |      8 | SQA  |
| 105 | www.oracle.com    |      7 | DBA  |
| 103 | sqa.fyicenter.com |      6 | SQA  |
| 101 | dev.fyicenter.com |      4 | DEV  |
| 106 | www.php.net       |      4 | DEV  |
+-----+-------------------+--------+------+
5 rows in set (0.00 sec)

 

SELECT Statements with JOIN and Subqueries in MySQL

⇒⇒MySQL Database Tutorials

2016-10-16, 184👍, 0💬