Kbase P4172: What are the Progress SQL-92 equivalents of 4GL FIND FIRST and FIND LAST?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/18/2002 |
|
Solution ID: P4172
GOAL:
What are the Progress SQL-92 equivalents of 4GL FIND FIRST and FIND LAST?
FACT(s) (Environment):
Progress 9.x
FIX:
-- Equivalent of FIND FIRST customer:
select * from pub.customer
where custNum = (select min(custNum) from pub.customer);
-- Equivalent of FIND LAST customer:
select * from pub.customer
where custNum = (select max(custNum) from pub.customer);