|
|
|
Junior Member
 
Group: Forum Members
Last Login: 8/20/2009 2:09:13 PM
Posts: 22,
Visits: 21
|
|
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
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 10/30/2009 6:28:19 AM
Posts: 34,
Visits: 117
|
|
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...
|
|
|
|