what is the best way to select fist non Null value from mutliple fiels K1,.... K3, I heard about case, but still can't figure out how to use single case fro multiple columns?
Appreciate your help.
select * from T01-- source table::::
PK K1 K2 K3
select PK, case (.....) from T01