You can limit the number of rows to be returned by using the maxrows attribute.
maxrows
<cfquery datasource="Entertainment" maxrows="50"> select * from Movies </cfquery>