Kbase P130714: SQL-92 equivalent of 4GL/ABL FIND FIRST/LAST statements
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/07/2008 |
|
Status: Unverified
GOAL:
What are the SQL-92 equivalents of the 4GL/ABL FIND FIRST/FIND LAST statements
GOAL:
How to retrieve the first or last record of a Progress table using SQL?
FACT(s) (Environment):
OpenEdge 10.x
Progress 9.x
All Supported Operating Systems
FIX:
Equivalent of the FIND FIRST statement:
select * from pub.customer
where custNum = (select min(custNum) from pub.customer);
Equivalent of the FIND LAST statement:
select * from pub.customer
where custNum = (select max(custNum) from pub.customer);