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:
“There could be no fairer destiny for any physical theory than that it should point the way to a more comprehensive theory in which it lives on as a limiting case.”
—Albert Einstein (1879–1955)
“If it is the result of a pure love, there can be nothing sensual in marriage. Chastity is something positive, not negative. It is the virtue of the married especially. All lusts or base pleasures must give place to loftier delights. They who meet as superior beings cannot perform the deeds of inferior ones.”
—Henry David Thoreau (1817–1862)
“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)