Select namaStaf, (Case when status = 'staff' Then 'Staff' End) as 'Staff', (Case when status = 'nonstaff' Then 'nonStaff' End) as 'nonStaff' From Coba pake Quey model gini.. thank u gan:beer::ilovekaskuss
misi gan mw tny misal ada kolom 'status' terus ada 2 nilai yaitu staff dan nonstaf cara munculin 2 nilai tersebut jadi kolom tersendiri gimana y? thx