Question

Sekali lagi tentang MYSQL ... mohon bantuannya (perintah dengan metode Select) ...

mohon bantuannya,

Answer 1

8. SELECT NIP, Karyawan.nama, kdkriteria, nilai FROM nilai
LEFT JOIN karyawan ON nilai.NIP= karyawan.NIP
LEFT JOIN kriteria ON nilai.kdkriteria=kriteria.kdkriteria
ORDER BY NIP, kdkriteria

9. SELECT NIP, Karyawan.nama, kdkriteria, Kriteria.nama, nilai FROM nilai
LEFT JOIN karyawan ON nilai.NIP= karyawan.NIP
LEFT JOIN kriteria ON nilai.kdkriteria=kriteria.kdkriteria
ORDER BY NIP, kdkriteria DESC

10. SELECT NIP, Karyawan.nama, kdkriteria, Kriteria.nama, nilai FROM Karyawan
LEFT JOIN nilai ON nilai.NIP= karyawan.NIP
LEFT JOIN kriteria ON nilai.kdkriteria=kriteria.kdkriteria
ORDER BY NIP, kdkriteria DESC

11. SELECT Nama FROM Karyawan WHERE NIP not in Nilai(NIP)

12. SELECT MAX(nilai) FROM nilai JOIN Karyawan ON nilai.NIP = Karyawan.NIP WHERE nama="nita"