Kbase P101780: SQL: Does SQL-92 support column aliases?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/10/2008 |
|
Status: Verified
GOAL:
SQL: Does SQL-92 support column aliases?
GOAL:
Does the Progress SQL support column aliases?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
Yes, SQL-92 supports the use of column aliases. For example:
SELECT "Cust-Num" AS "CustomerNumber", "Cust-Name" AS "CustomerName" FROM PUB.Customer;