Like there is in MySQL?

I.e. SELECT <fields> FROM <tables> WHERE LIMIT 1