Question #76376
What is CUST in the statement below?
SELECT CUST.CUSTOMERNAME
FROM CUSTOMER_T CUST
WHERE CUSTOMER_STATE = 'TX'
a column alias
a synonym
a table alias
an aggregate function
SELECT CUST.CUSTOMERNAME
FROM CUSTOMER_T CUST
WHERE CUSTOMER_STATE = 'TX'
a column alias
a synonym
a table alias
an aggregate function
Expert's answer
The correct answer: a table alias
CUST is the alias of the table «CUSTOMER_T». It is used to make SQL easier to
read.
CUST is the alias of the table «CUSTOMER_T». It is used to make SQL easier to
read.
