All Forums Tools
az_maverick 24 posts Joined 03/09
20 Aug 2009
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

ANIMESH.DUTTA 35 posts Joined 05/09
21 Aug 2009

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

Animesh Dutta
Teradata Certified Master

You must sign in to leave a comment.