Restrictions with Subqueries

I started doing some subqueries in SQL and I have a doubt whether there are any restrictions in using subqueries. If so what are they?

In oracle8 and prior releases you can't use [B]order by clause[/B] in your sub-query.


Regards,
James