Select only a few?

[Anon]

What is the SQL syntax to select only the top 5 or so entries in a table? Similar to how the forum here at phpbuilder.com works?

Thanks

[cornelalexa]

select * from table limit (1,10);

Will get the first 10 rows started from the 1.