Selecet top 5 rows in MySQL?

[Stacy]

Hi All,

I'm using MySQL and ASP and I'm trying to come up with a SQL statement that selects only the 5 top results, from one of my MySQL tables. Is this possible to be done in MySQL or I'll have to select everything in the table and then just get the first 5 rows returned from the ASP code?



Thank you!

Stacy

[Don]

Yes you can do that with MySQL. It should be something like that:

SELECT * FROM tblYourTable LIMIT 0,5




Don

[Stacy]

Thanks Don,

If I execute the following MySQL statement, what will it do:

SELECT * FROM tblYourTable LIMIT 4,5

Would it get rows # 4 and 5?



Thanks again,