can I do a SELECT TOP 4 * FROM TblTest

[Anon]

In ms SQL Server I've used SELECT TOP 4 to get the top 4 records in a recordset. In very new to MySQL, can this be done. I've tried it but it did not work. Any ideas??
Many thanks

[brandonschnell]

select col from table order by col desc limit 4;

[Anon]

cheers!