Example: Asterisks in SELECT Lists - Analytics Database - Teradata Vantage

SELECT *
FROM policy;

Result:

Policy_ID  Customer_ID  Policy_Type  Policy_Details
---------  -----------  -----------  ------------------
   541077    766492008  AU           STD-CH-344-YXY-00
   541008    246824626  AU           STD-CH-345-NXY-00
   541145    616035020  AU           STD-CH-348-YXN-01

SELECT policy.*, validity
FROM Policy;

Result:

Policy_ID  Customer_ID  Policy_Type  Policy_Details    Validity
---------  -----------  -----------  ----------------- ------------------------
541077     766492008    AU           STD-CH-344-YXY-00 ('09/12/21', '99/12/31')
541008     246824626    AU           STD-CH-345-NXY-00 ('09/10/01', '99/12/31')
541145     616035020    AU           STD-CH-348-YXN-01 ('09/12/03', '10/12/01')