oracle sql case

JointLantic

6 years ago

oracle sql case

oracle sql case or case statement in sql

SELECT a.emplid,
  case when a.ts_percentage >= 85 then  'G'
  else case when  a.ts_ranking1 >= '3' and a.ts_ranking2 >= '3'  then  'G'
       else case when  (a.ts_ranking1 >= '3' and a.ts_percentage2 >= 85)  then  'G'
       else case when  (a.ts_ranking2 >= '3' and a.ts_percentage1 >= 85)  then  'G'
       else
       'T' 
  end end end end end end type
from ps_ts_score a

SELECT a.emplid,

case when a.ts_percentage >= 85 then 'G'

else case when a.ts_ranking1 >= '3' and a.ts_ranking2 >= '3' then 'G'

else case when (a.ts_ranking1 >= '3' and a.ts_percentage2 >= 85) then 'G'

else case when (a.ts_ranking2 >= '3' and a.ts_percentage1 >= 85) then 'G'

else

'T'

end end end end end end type

from ps_ts_score a