Collections:
Returning Top 5 Rows in MySQL
How To Return Top 5 Rows in MySQL?
✍: FYIcenter.com
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)
⇒ Returning the Second 5 Rows in MySQL
⇐ Counting Groups Returned from GROUP BY in MySQL
2017-12-21, 1385🔥, 0💬
Popular Posts:
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...