MySQL SQL - How To Return Top 5 Rows

How To Return Top 5 Rows

Q

How To Return Top 5 Rows? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries

✍: 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)

2007-05-11, 6484👍, 0💬

How To Use Subqueries in the FROM clause
How To Use Subqueries in the FROM clause? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries If you have a query returning many rows of data, and you want to perform another query on those rows, you can put the first query as a subquery in the FROM clause of the second query. A subquery u... 2007-05-11, 6183👍, 0💬

How To Return the Second 5 Rows
How To Return the Second 5 Rows? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries If you want to display query output in multiple pages with 5 rows per page, and the visitor wants to see the output for the second page, you need to display query output from row 6 to row 10. You can use t... 2007-05-11, 5932👍, 0💬

How To Count Groups Returned with the GROUP BY Clause
How To Count Groups Returned with the GROUP BY Clause? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries If you use the COUNT(*) function on groups returned with the GROUP BY clause, it will count the number of rows within each group, not the number of groups. If you want to count the nu... 2007-05-11, 5098👍, 0💬

How To Use UNION to Merge Outputs from Two Queries Together
How To Use UNION to Merge Outputs from Two Queries Together? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries If you have two queries that returns the same row fields, you can merge their outputs together with the UNION operator. The following tutorial exercise shows you how to return a... 2007-05-11, 4739👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.