Posted on July 5, 2012 by Maurice RuckmanLimit SQL Results Use rownum to keep the returned rows at a reasonable result select * from mytable where rownum < 10