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, 1395🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...