sql - GROUP BY without aggregate function - Stack Overflow
Nov 19, 2013· Would create a problem: the line with A, Y is the result of grouping the two lines. A Y 2 A Y 3 So, which value should be in Col3, '2' or '3'? Normally you would use a GROUP BY to calculate e.g. a sum: SELECT Col1, Col2, SUM(Col3) FROM data GROUP BY Col1, Col2 So in the line, we had a problem with we now get (2+3) = 5.
Read More