MYSQL -Top 6 -Return the top 6 rows

[JimFL]

Hi,

Can anybody help me to produce similar functionality to the top T-SQL command.

In sql server you can return the top 6 rows of a bigger query by using the top command.
For example

select top 6 .*
from countries

Im sure this is quite straight forward but I cant find the syntax.

James

 

[lgarner]

select * from countries limit 6" is probably what you want. You can also include an "order by" clause to determine what's considered at the "top

 

[JimFL]

brill thanks