You can limit the amount of rows you receive in the results by using the LIMIT clause

At the end of the query, simply write

LIMIT

where is the amount of rows you want to limit the output to.

for example

select * from products

LIMIT 10

would only show 10 products from the products table