'Teradata looping through columns (using parameter)

I have a single query in teradata sql assistant:

select ID from RetailSales;

I want to execute this query multiple times with different columns in select statement

Ex: select Name from RetailSales, select DOB from RetailSales,.. so on for 10 columns.

Is there any way to do it (without creating macros or procedures)?

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source