Skip to content

Instantly share code, notes, and snippets.

@rizkytegar
Last active October 28, 2023 05:56
Show Gist options
  • Save rizkytegar/b9eaa4c069878b7864d0b0d9a2c6d56b to your computer and use it in GitHub Desktop.
Save rizkytegar/b9eaa4c069878b7864d0b0d9a2c6d56b to your computer and use it in GitHub Desktop.
SELECT p.nama AS 'NAMA MANAGER'
FROM `pegawai` AS p
WHERE p.id_pegawai IN (SELECT id_manager FROM `pegawai`)
ORDER BY p.id_pegawai asc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment