Please enable JavaScript.
Coggle requires JavaScript to display documents.
Structure Query Language, SUM - Coggle Diagram
Structure Query Language
2 Komponen
Data Definition Language
CREATE
ALTER
DROP
Berfokus pada
database
Data Manipulation Language
SELECT
INSERT TO
UPDATE
DELETE
Berfokus pada
tabel
Modul
Modul 1
Primary Key
Berisi data yang unik (tidak dapat diduplikat
Foreign Key
Menghubungkan tabel utama dengan tabel turunan
Like
Berisi data yang sama
Modul 2
DISTINCT
ORDER BY
Descending (0-9)
Ascending (9-0)
GROUP BY
Fungsi Agregrat
COUNT
AVG
MIN
MAX
WHERE
HAVING
Modul 3
Relasi
Hubungan antar tabel
Join
Gabungan antar 2 tabel atau lebih
Inner Join
Left Outer Join
Right Outer Join
Full Outer Join
Cross Outer Join
Union
Natural Join
Nested Join
SUM