Insert "TOP 10" after the SELECT in the SQL query.

SELECT TOP 10 * FROM YourTable