use the "limit" statement: select stuff from some_table where stuff.blah > 12 limit 5
limit
select stuff from some_table where stuff.blah > 12 limit 5