Difference between select * from Table & select individual columns

Tools
Enthusiast

Difference between select * from Table & select individual columns

Hello all,
I am having trouble understanding difference select * from TABLE X or select a , b, c ( columns) from table X ( same table ) above.
I was wondering if someone actually knows what is the difference at the Teradata DB Architecture level.

Thanks,
Aditi
1 REPLY
Enthusiast

Re: Difference between select * from Table & select individual columns

I don't think any difference as such.
But if you use to fetch records from a subquery and use those columns in the outer query - you need to specify column names exclusively in the sub-query.
As a standard - we generally avoid asterisk (*) as developers will get the full idea by looking at the query directly...