Jawatan: TIMBALAN NAIB CANSELOR HAL EHWAL PELAJAR DAN ALUMNI
Email: asmadi[at]kuipsas.edu.my
Nombor Extension: 5453
Pentadbiran: PENGURUSAN KANAN
Whole query: SELECT * FROM kipsasapps.kelayakantinggi
WHERE idPekerja = '20'
ORDER BY
CASE
WHEN taraf = 'PhD' THEN 1
WHEN taraf = 'Sarjana' THEN 2
WHEN taraf = 'Master' THEN 2
WHEN taraf = 'Ijazah Sarjana Muda' THEN 3
WHEN taraf = 'Degree' THEN 3
WHEN taraf = 'Diploma' THEN 4
ELSE 5
END
