How can one indicate the maximum number of result records that should be returned in an SQL string?
E.g. when a DB table containing 5000000 records is read out with an SQL query, the WHERE clause can filter the number of records, but can return up to 5M records. Is it possible to indicate in the SQL query the maximum number of records that should be returned to optimize performance?