Re: Display duplicate rows

[Plamen Ratchev]

What happens when you add the column WQR_TDH_HEADER_ID to both SELECT and
GROUP BY? If you get rows you consider non-duplicate show as duplicate, then
most likely your grouping does not include all significant columns to
consider one row unique.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

[Charlie]

I would like to group by fewer columns, but I get an error trying to
compile.
As an example, eleminating the SHIFT column from group by gives the
following error:

Msg 8120, Level 16, State 1, Procedure PWQR_Select_Teardown_15_Day_Summary,
Line 26

Column 'TWQRHISTEARDOWN_HEADER.WQR_TDH_SHIFT_X' is invalid in the select
list because it is not contained in either an aggregate function or the
GROUP BY clause.

"Plamen Ratchev" <Pl****@SQLStudio.comwrote in message
news:HZ******************************@speakeasy.ne t...

What happens when you add the column WQR_TDH_HEADER_ID to both SELECT and
GROUP BY? If you get rows you consider non-duplicate show as duplicate,
then most likely your grouping does not include all significant columns to
consider one row unique.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

[Plamen Ratchev]

Actually I mean the opposite, you may need to add more columns to both
SELECT/GROUP BY to get correct results.

You do need to have the columns in the SELECT list as part of the GROUP BY
clause.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

[Charlie]

I am kind of new to this. Does each column in SELECT require a GROUP BY? I
am getting an error if I don't include all SELECT columns in GROUP BY
columns. I only need to group by around four columns, but need to display
all columns in SELECT.

Thanks for the help.

Charlie

"Plamen Ratchev" <Pl****@SQLStudio.comwrote in message
news:OM******************************@speakeasy.ne t...

Actually I mean the opposite, you may need to add more columns to both
SELECT/GROUP BY to get correct results.

You do need to have the columns in the SELECT list as part of the GROUP BY
clause.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

[Plamen Ratchev]

I actually already listed aggregate functions: "...only grouping columns,
aggregate functions, or constant expressions...".

Plamen Ratchev
http://www.SQLStudio.com