SELECT Jadwal.No_Jadwal, Kuliah.No,Doseen.Nama_Dosen , slot.id_slot,count(*) 'Jumlah Bentrok ' FROM Jadwal INNER JOIN Kuliah ON Jadwal.No = Kuliah.No INNER JOIN slot ON Jadwal.id_slot = slot.id_slot INNER JOIN Doseen ON Kuliah.Id_Dosen = Doseen.Id_Dosen group by Jadwal.No_Jadwal, Kuliah.No,Doseen.Nama_Dosen ,slot.id_slot having count(*) > 1
SELECT [id_slot], count(*) 'Jumlah Bentrok' FROM [FKIP-UNILAK].[dbo].[Jadwal] group by [id_slot] having count(*) > 1
view
count
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)