Selasa, 25 November 2014
Senin, 24 November 2014
PEMROGRAMAN SQL PART VII
ALJABAR RELATIONAL
SELECT nim,
COUNT (nilai) AS nilai_muncul,
SUM (nilai) AS total_nilai
FROM nilai1
WHERE nim='201291002'
group by nim;
SELECT nim,
COUNT (nilai) AS nilai_muncul,
SUM (nilai) AS total_nilai
FROM nilai1
WHERE nim='201291005'
group by nim;
SELECT nim,
COUNT (nilai) AS nilai_muncul,
SUM (nilai) AS total_nilai
FROM nilai1
WHERE nim='201291002'
group by nim
UNION
SELECT nim,
COUNT (nilai) AS nilai_muncul,
SUM (nilai) AS total_nilai
FROM nilai1
WHERE nim='201291005'
group by nim;
SELECT nim,
COUNT (nilai) AS nilai_muncul,
SUM (nilai) AS total_nilai
FROM nilai1
WHERE nim='201291002'
group by nim
INTERSECT
SELECT nim,
COUNT (nilai) AS nilai_muncul,
SUM (nilai) AS total_nilai
FROM nilai1
WHERE nim='201291005'
group by nim;
DISTICNT
Tampilkan nilai berdasarkan kode matakuliah, dengan
menghilangkan data yang bernilai ganda
JOINT
~Denganmenggunakansintax joint
tampilkan nama matakuliah, SKS, dan nilai
~Tampilkannamamahasiswa, kota, nilai
~Tampilkannamamatakuliah,
nama mahasiswa, dan nilai
SELECT nama_mk, sks, nilai
FROM matakuliah JOIN nilai
ON matakuliah.kode_mk=nilai1.kode_mk;
SELECT nama, kota, nilai
FROM mahasiswa JOIN nilai1
ON mahasiswa.nim=nilai1.nim;
Select nama, nama_MK, nilai
from mahasiswa join nilai1 on mahasiswa.nim = nilai1.nim
join matakuliah1 on matakuliah1.kode_MK = nilai1.kode_MK
from mahasiswa join nilai1 on mahasiswa.nim = nilai1.nim
join matakuliah1 on matakuliah1.kode_MK = nilai1.kode_MK
CROSS PRODUCT
Langganan:
Postingan (Atom)
0 komentar: