Using default column with group by statement

Question

I want to use Default value column in GROUP BY. The default column is created in Select statement.

I have tried to use the default column value 'A' in group by(I know i cannot use the alias value).

This is what I have tried.

Select Name, 'A' as 'ID',SUM(Amount) FROM Customer
GROUP BY Name, 'A'

I am getting the following error message:

Msg 164, Level 15, State 1, Line 18 Each GROUP BY expression must contain at least one column that is not an >outer reference.

As 'A' is a constant, you don't need to add it to the group by list. And having single quotes around 'ID' might be causing issues too. Get rid of them or use [ID]. — TomC
– TomC, Commented Jun 6, 2019 at 6:24

Michał Turczyn · Accepted Answer · 2019-06-06 06:23:25Z

3

Grouping by that additional column will not do any difference and will be the same as:

Select Name, 'A' as 'ID',SUM(Amount) FROM Customer
GROUP BY Name

answered Jun 6, 2019 at 6:23

Michał Turczyn

41.2k18 gold badges58 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gordon Linoff Over a year ago

Well, technically adding 'A' to the GROUP BY does make a difference because it results in an error. However, if it worked, it wouldn't logically affect the results.

Collectives™ on Stack Overflow

Using default column with group by statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related