grouping by the result of a case statement 3

[link9]

Hello all --

How do I group by the result of a case statement???

ex)
SELECT typeRRS = CASE WHEN demo.typeRRS = 1 OR demo.typeRRS = 2 THEN 1 ELSE 3 END
FROM tableName
GROUP BY typeRRS

This statement groups the result set by demo.typeRRS, not the resulting 1 or 3 that comes out of the statement...

Thanks!
Paul Prewett

 

[tlbroadbent]

Use the CASE statement in the GROUP BY clause.

SELECT typeRRS = CASE WHEN demo.typeRRS = 1 OR demo.typeRRS = 2 THEN 1 ELSE 3 END
FROM tableName
GROUP BY CASE WHEN demo.typeRRS = 1 OR demo.typeRRS = 2 THEN 1 ELSE 3 END
Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[link9]

Ahhhhhhhhh..... thank you.