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 poet sings how the blood flows in his veins. He performs his functions, and is so well that he needs such stimulus to sing only as plants put forth leaves and blossoms.... His song is a vital function like breathing, and an integral result like weight.”
—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)