SHARE
TWEET

Untitled

a guest Mar 26th, 2019 69 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT * FROM tmp_proses_d20an_biner_tunggal  A INNER JOIN tmp_proses_d20an_biner_tunggal B
  2. ON A.nim = B.nim AND A.masa = B.MASA AND A.KODE_TEMPAT_UJIAN != B.KODE_TEMPAT_UJIAN AND
  3. A.KODE_JENIS_D20AN = B.KODE_JENIS_D20AN AND A.cetakan_ke = B.cetakan_ke AND A.HARI = B.HARI
  4. WHERE A.MASA = '20182'  AND  
  5.    (A.KODE_MTK_1 = (B.kode_mtk_1 OR B.kode_mtk_2 OR B.kode_mtk_3 OR B.kode_mtk_4 OR B.kode_mtk_5 )  
  6. OR A.KODE_MTK_2 = (B.kode_mtk_1 OR B.kode_mtk_2 OR B.kode_mtk_3 OR B.kode_mtk_4 OR B.kode_mtk_5 )  
  7. OR A.KODE_MTK_3 = (B.kode_mtk_1 OR B.kode_mtk_2 OR B.kode_mtk_3 OR B.kode_mtk_4 OR B.kode_mtk_5 )
  8. OR A.KODE_MTK_4 = (B.kode_mtk_1 OR B.kode_mtk_2 OR B.kode_mtk_3 OR B.kode_mtk_4 OR B.kode_mtk_5 )
  9. OR A.KODE_MTK_5 = (B.kode_mtk_1 OR B.kode_mtk_2 OR B.kode_mtk_3 OR B.kode_mtk_4 OR B.kode_mtk_5 ))
  10. GROUP BY  A.KODE_TEMPAT_UJIAN
  11. ORDER BY A.NAMA_MAHASISWA;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top