Jawatan: TIMBALAN NAIB CANSELOR PENYELIDIKAN DAN INOVASI
Email: effat[at]unipsas.edu.my
Nombor Extension: 5444
Pentadbiran: PENGURUSAN KANAN
Whole query: SELECT * FROM kipsasapps.kelayakantinggi
WHERE idPekerja = '14'
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
