Jawatan: TIMBALAN NAIB CANSELOR AKADEMIK DAN PENGANTARABANGSAAN
Email: rosli[at]kipsas.edu.my
Nombor Extension: 5530
Pentadbiran: PENGURUSAN KANAN
Whole query: SELECT * FROM kipsasapps.kelayakantinggi
WHERE idPekerja = '101'
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
