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

1

image

2

It just gives the column a name, for example:

SELECT '' AS CEC_UNIT;

can also be written as

SELECT CEC_UNIT = '';

1 Like
3

Thanks RogierPronk! I appreciate it!

4

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