Kbase P129269: Can the DISTINCT and the TOP clauses be used on the same SELECT query?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/27/2008 |
|
Status: Unverified
GOAL:
Can the DISTINCT and the TOP clauses be used on the same SELECT query?
GOAL:
Can the DISTINCT and the TOP functions be used on the same SELECT query?
GOAL:
Can the DISTINCT and the TOP phrases be used on the same SELECT query?
GOAL:
Does the DISTINCT and the TOP clauses go on the same SELECT query?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B
FIX:
Yes, the TOP and the DISTINCT functions can be used on the same select query. The TOP clause should be interpreted last when there are aggregate functions such as SUM or MAX, GROUP BY clause and DISTINCT phrase are used, for instance,
SELECT DISTINCT TOP 10 * from PUB.customer
or
SELECT DISTINCT TOP 10 custnum from PUB.customer