Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Limit rows returned 1
- Thread starter pauljt
- Start date
- Thread starter
- #2
-
1
- #3
Obviously you can limit the amount fo rows returned by using WHERE clauses. But if you only want the first 5 rows, when 100 satisfy the WHERE clauses, then you can code:
FETCH FIRST 5 ROW ONLY
to the select statement. After 5 rows have been obtained (or however many you need) an SQLCODE of 100 will be returned.
Hope this helps.
Marc
FETCH FIRST 5 ROW ONLY
to the select statement. After 5 rows have been obtained (or however many you need) an SQLCODE of 100 will be returned.
Hope this helps.
Marc
- Thread starter
- #4
- Status