Ingres 11.0 | Using the Retrieve Statement Without a Loop

QUEL Reference Guide > QUEL Reference Guide > Embedded QUEL > Retrieve Statement > Using the Retrieve Statement Without a Loop

Was this helpful?

Using the Retrieve Statement Without a Loop

You can code a retrieve statement without an accompanying loop; in this case, one row, at most, is retrieved. This is appropriate, for instance, when your query seeks an exact match for a unique key. However, if more than one row qualifies according to the where clause, only one of the matching rows is returned.

Last modified date: 01/30/2023