Order by does not work in subqueries in 8. In 8i it works fine.