Need a unique gift idea?
A Pastebin account makes a great Christmas gift
SHARE
TWEET

Untitled

a guest Dec 6th, 2018 59 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
 
  1. SELECT NIS, KELAS FROM NILAI WHERE NILAI_ANGKA > 50 AND KODE_MAPEL = 'BHS'
  2.  
  3. SELECT * FROM SISWA WHERE jenis_kel = 'P' AND tempat_alamat = 'Jogja' OR alamat = 'Jogja'
  4.  
  5. SELECT nis FROM NILAI
  6.  
  7. SELECT kode_mapel FROM NILAI where thn_ajaran = '2014/2015' AND semester = 'Genap'
  8.  
  9. SELECT TOP 5 nis FROM NILAI WHERE kelas = '9A' AND kode_mapel = 'BHS' ORDER BY nilai_angka DESC
  10.  
  11. ////
  12.  
  13. SELECT COUNT (DISTINCT(kode_mapel) FROM NILAI WHERE NIP = 'G19020340'
  14.  
  15. SELECT COUNT (DISTINCT(jenis_kel) FROM SISWA WHERE NAMA LIKE '_A_A%'
  16.  
  17. SELECT AVG (nilai_angka) FROM NILAI WHERE kelas = '9A' AND thn_ajaran = '2014/2015' AND semester = 'Ganjil'
  18.  
  19. SELECT TOP 1 nis, kelas FROM NILAI where kode_mapel = 'BHS'
  20.  
  21. SELECT nis, SUM(nilai_angka) FROM NILAI GROUP BY nis
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