How to limit the number of records retrieved with a select statement: 

    Select * from myTable LIMIT 10