hi..,
query1:
select income,
(case when income between 0.00 and 2000.00 then 'Bucket1'
when income between 2001.00 and 3000.00 then 'Bucket2'
when income between 3001.00 and 4000.00 then 'Bucket3'
when income between 4001.00 and 6000.00 then 'Bucket4'
when income between 6001.00 and 10000.00 then 'Bucket5'
else 'Bucket6' end) as bucket
from bi02_customer group by bucket;
query 2:
select salbucket from m_caprosel;
query1 result:
income bucket
----------------
1000 bucket1
2000 bucket2
3000 bucket3
query2 result:
salbucket
---------
bucket3
expected result:
income from matched records od both queryies.
Pls could u tell me any one..
View Complete Post