SQLTeam.com | Weblogs | Forums

What does it mean to have column names equal to something in select statement

image

It just gives the column a name, for example:

SELECT '' AS CEC_UNIT;

can also be written as

SELECT CEC_UNIT = '';

1 Like

Thanks RogierPronk! I appreciate it!

The actual term I believe is 'column alias' - and you can use that to rename an existing column name to something more appropriate for the calling application/user.

1 Like