SQL LIMIT

[wxdqz]

I use MySQL Database and Php.

I limit the result retrieve from database by below query :

Select * from Friend Limit 10;

P/s : don't bother about order by.

It's work well, it did the job.

So if i want to use other database like
PostgreSql, Mssql , ODBC databases, Oracle,
i think i couldn't use the "limit".

May i know how to limit the record retrieve
from other database instead of mysql ?

Thanks for answering.