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.
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...