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:
“A way of certifying experience, taking photographs is also a way of refusing it—by limiting experience to a search for the photogenic, by converting experience into an image, a souvenir. Travel becomes a strategy for accumulating photographs.”
—Susan Sontag (b. 1933)
“Fate then is that necessity by which a certain result will surely be brought to pass according to the natural course of events however we may vary the particular circumstances which precede the event.”
—Charles Sanders Peirce (1839–1914)
“Creatures that hang themselves up like an old rag, to sleep;
And disgustingly upside down.
Hanging upside down like rows of disgusting old rags
And grinning in their sleep.
Bats!”
—D.H. (David Herbert)