Mo' Oracle fun.

To get the top 10 rows in SQL Server, you'd use:

SELECT TOP 10 * FROM TABLE1

In Oracle, you use...

SELECT * FROM TABLE1 WHERE ROWNUM <= 10

Love me some nonstandard SQL implementations. Working with Oracle & SQL Server is like working with IE & NS again. And when I say NS, I mean Netscape 4.x, where they were just as eager to shove their proprietary layers on us as Microsoft was with IE specific jive. Feeeee-uhn.