Kbase P21463: Is it possible to limit the result set of a SQL92 query?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/03/2009 |
|
Status: Verified
GOAL:
How to limit the result set of a SQL92 query?
GOAL:
Is it possible to limit the result set of a SQL92 query by using TOP?
GOAL:
Are there any plans to implement the ROWNUM operation?
FACT(s) (Environment):
OpenEdge 10.1x
OpenEdge 10.2x
All Supported Operating Systems
FIX:
There are no plans to implement support for the Oracle ROWNUM operation.
OE sql has implemented the much better ability to limit the rows returned by an OpenEdge SQL query at the statement level by using the TOP syntax ("TOP n" ) as found in other DBMS like MS SQL Server and IBM DB2.
The Oracle ROWNUM has a bunch of tricky rules when you use it. TOP is much simpler and easier and reliable to use.
TOP is implemented into the OpenEdge product since OpenEdge version 10.1B