Kbase P15826: Using GROUP BY and Function with SQL92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
Using GROUP BY and Function with SQL92
FIX:
See a sample below of using a Function and a GROUP BY clause
SELECT customer."cust-num", NVL("order"."order-num",1)
FROM customer, "order"
WHERE customer."cust-num" = NVL("order"."order-num",1)
GROUP BY customer."cust-num", "order"."order-num";