Limiting Result Rows
Often it is convenient to indicate a maximum number of rows that are returned. This can be used for testing or to prevent consuming excessive resources if the query returns more information than expected. The approach to do this often varies per vendor.
In ISO SQL:2003, result sets may be limited by using
- cursors, or
- By introducing SQL window function to the SELECT-statement
ISO SQL:2008 introduced the FETCH FIRST clause.
Read more about this topic: Select (SQL)
Famous quotes containing the words limiting, result and/or rows:
“Do we honestly believe that hopeless kids growing up under the harsh new rules will turn out to be chaste, studious, responsible adults? On the contrary, by limiting welfare, job training, education and nutritious food, won’t we plant the seeds for another bumper crop of out-of-wedlock moms, deadbeat dads and worse?”
—Richard B. Stolley (20th century)
“The result of civilization, at the Sandwich Islands and elsewhere, is found productive to the civilizers, destructive to the civilizees. It is said to be compensation—a very philosophical word; but it appears to be very much on the principle of the old game, “You lose, I win”: good philosophy for the winner.”
—Herman Melville (1819–1891)
“Over the low, barnacled, elephant-colored rocks,
Come the first tide-ripples, moving, almost without sound, toward
me,
Running along the narrow furrows of the shore, the rows of dead clam shells;”
—Theodore Roethke (1908–1963)