Need help
Below is my query
I would like the 99999 to generate in the data when any of the these numbers are included (10114,10135,10043). But if there are any other numbers use 99998.
select chg.location, aa.*
from
(select * from TABLE
where location=10135
)aa, TABLE chg
where if (aa.location=(10135) then
(select * from TABLE
where location=99999) else
(select * from TABLE
where location=99998)
)