Limit number of listings

[NeedHelp]

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?

[smith]

Yup, just add a LIMIT 0,25

The 0 is where to start and the 25 is the max number of results.

[smith]

SELECT * FROM tbl LIMIT 0,25;

[husky44]

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.

[Jordan]

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.