Is it possible to use in() clause in case.. when ...the construction in sql query condition expression.
im my case the query is very long:
select r.insurance_package_id,r.name,
max(case r.insurance_package_id when 6 then r.name
when 7 then r.name
when 8 then r.name
when 9 then r.name
when 10 then r.name
when 11 then r.name
when 12 then r.name
when 14 then r.name
when 42 then r.name
when 44 then r.name
when 7 then r.name
end) CPI_Life
there are about 200 id supposed to be used in condition expression: thus, the query would be very brut.
Aucun commentaire:
Enregistrer un commentaire