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
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