Group By Nullable Column In Teradata

Question

What happens when I group by a column in Teradata which is nullable ? Are those records which have the corresponding field's value AS NULL get eliminated ? Please Explain with an example !

score 2 · Accepted Answer · answered Jul 03 '15 at 18:35

2

Every DBMS treats NULLs in the GROUP BY columns like any other value and puts them into one group. Eliminated are NULLs in the aggregated columns.

Why don't you simply test it?

answered Jul 03 '15 at 18:35

dnoeth

59,503
4
39
56

Group By Nullable Column In Teradata

1 Answers1