how to combine the related version in group by

Posted by randeepsp on Stack Overflow See other posts from Stack Overflow or by randeepsp
Published on 2010-03-19T12:27:59Z Indexed on 2010/03/19 12:31 UTC
Read the original article Hit count: 218

Filed under:
|
|

select count(a),b,c from APPLE join MANGO on (APPLE.link=MANGO.link) join ORANGE on (APPLE.link=ORANGE.link) where id='camel' group by b,c;

the column b gives values like 1.0 1.0,R 1.0,B 2.0 2.0,B 2.0,R 3.0,C 3.0,R

is there a way to modify the above quer so that all 1.0 and 1.0,R and 1.0,B are merged as 1.0 and 2.0,2.0,B are merged as 2.0 and same way for 3.0 and 4.0

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about sql