SELECT departemen.id AS departemen_id, departemen.parent_id AS departemen_parent_id, departemen.kategori AS departemen_kategori, departemen.alamat AS departemen_alamat, departemen.singkat AS departemen_singkat, departemen.level_id AS departemen_level_id, departemen.nama AS departemen_nama, departemen.kode AS departemen_kode, departemen.status AS departemen_status, departemen.created AS departemen_created, departemen.updated AS departemen_updated, departemen.create_uid AS departemen_create_uid, departemen.update_uid AS departemen_update_uid
FROM departemen ORDER BY departemen.nama