Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Return Top 5 Rows
How To Return Top 5 Rows? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries
✍: 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)
2007-05-11, 7165👍, 0💬
Popular Posts:
How do you locate the first X in a string txt? A) txt.find('X'); B) txt.locate('X'); C) txt.indexOf(...
How To Retrieve the Count of Updated Rows? - Oracle DBA FAQ - Working with Database Objects in PL/SQ...
How do you open an SSH connection to a remote box? ????
Can you explain project life cycle ? Figure :- 12.2 Life cycle of a project There are five stages of...
From performance point of view how do they rate ? Repeater is fastest followed by Datalist and final...