For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Is it recommend to implement MySQL Enterprise Monitor in Production servers? will it affect the performance?
SELECT customer_key , GREATEST ( bb , cl , la ) AS spend FROM TABLE_X ;
SELECT customer_key , GREATEST ( bb , cl , la ) AS spend , CASE WHEN bb >= GREATEST (cl, la) THEN 'BB' WHEN cl >= la THEN 'CL' ELSE 'LA' END AS column_name FROM table_x ;
SELECT customer_key,GREATEST(bb,cl,la) AS spend CASE GREATEST(bb,cl,la) when bb then 'BB' when cl then 'CL' when la then 'LA' END AS column_name FROM table_x;