Select Top .... ?

[Kinl]

I want to select the top 20 records from my table, but I dont know how to do it. I know you can do it in SQL Server, but I'm still new to mySQL.

How would you select the top 10 records of a table based on a where clause?

This is how i'd do it in SQL Server.:

select top 10 fname from Customers

How can i do this in mySQL?

Thanx

shorty

 

[piti]

try this one

select fname from Customers LIMIT 10[color]

or equiv

select fname from Customers LIMIT 0, 10[color]

 

[Kinl]

Thank you!