Sign In
Create Account
Follow Us on Twitter
Subscribe on Youtube
Is there a way in MySQL to limit how many results are shown?
SELECT * FROM tbl;
but I only want say, 25 results. Is this possible?
Limit number of listings
Started by
Guest_NeedHelp_*
, Jul 14 2006 08:32 AM
4 replies to this topic
Back to top|
|
|
#2
Posted 15 July 2006 - 05:26 PM
smith
-
- Members
-
- 153 posts
Programmer
Yup, just add a LIMIT 0,25
The 0 is where to start and the 25 is the max number of results.
The 0 is where to start and the 25 is the max number of results.
for (int i;;) {
cout << "Smith";
}
#3
Posted 15 July 2006 - 05:27 PM
smith
-
- Members
-
- 153 posts
Programmer
#4
Posted 16 July 2006 - 09:17 PM
husky44
-
- Members
-
- 30 posts
Learning Programmer
I know there is a command for Top 10 or something.. how does that one work?
Sorry to slightly stray here, but it is still kind of relevant.
Sorry to slightly stray here, but it is still kind of relevant.
#5
Guest_Jordan_*
Posted 17 July 2006 - 04:52 AM
Guest_Jordan_*
Guest_Jordan_*
-
- Guests
You can do a ORDER BY to get the top ten combined with limit
SELECT * FROM tbl ORDER BY clm_num LIMIT 0,10;
Do to in reverse order do
SELECT * FROM tbl ORDER BY clm_num LIMIT 0,10 DESC; // Descending Order
You can also ORDER by multiple columns in your table
SELECT * FROM tbl ORDER BY clm_num, clm_name LIMIT 0,10;
If the column is character it will be sorted alphabetical.
SELECT * FROM tbl ORDER BY clm_num LIMIT 0,10;
Do to in reverse order do
SELECT * FROM tbl ORDER BY clm_num LIMIT 0,10 DESC; // Descending Order
You can also ORDER by multiple columns in your table
SELECT * FROM tbl ORDER BY clm_num, clm_name LIMIT 0,10;
If the column is character it will be sorted alphabetical.
