create table t124(Ownr varchar(40),Grp varchar(50))insert into t123 values('ravi','Apple')insert into t123 values('ravi','Grapes')insert into t123 values('ravi','Mango')insert into t123 values('ravi','Apple')select grp,case Grp when 'Apple' then 'Red' when 'Grapes' then 'Green' when 'Mango' then 'Yellow' end [Process] from t123