Read "Limiting result rows" to learn how various SQL implementations restrict the number of rows returned by the SELECT command.