Piyé cara sampeyan nangani duplikat nganggo DISTINCT?

Question

Accepted Answer

**`DISTINCT`** ngilangi baris-baris duplikat saka hasil, mbalekake mung nilai-nilai sing unik. Iki digunakake kanggo nggoleki nilai-nilai sing beda-beda saka kolom (utawa kombinasi kolom) — umum kanggo nggoleki entri-entri sing unik utawa mbangun daftar dropdown.

## DISTINCT — nilai-nilai sing unik

```sql
-- get the unique countries (no duplicates)
SELECT DISTINCT country FROM users;
-- → each country appears once, even if many users share it

-- DISTINCT on multiple columns → unique COMBINATIONS
SELECT DISTINCT country, city FROM users;
-- → each unique (country, city) pair appears once
```

`DISTINCT` nangsung menyang kabeh kolom sing dipilih bebarengan — `DISTINCT country, city` mbalekake kombinasi-kombinasi sing unik, dudu negara-negara sing unik lan kutha-kutha sing unik kanthi pisah.

## DISTINCT karo COUNT

```sql
-- count how many UNIQUE countries there are
SELECT COUNT(DISTINCT country) FROM users;

-- vs COUNT(*) which counts all rows (with duplicates)
SELECT COUNT(*) FROM users;
```

`COUNT(DISTINCT column)` ngetung nilai-nilai sing unik — migunani kanggo "pira akeh X sing beda-beda?"

## Nggoleki baris-baris duplikat sing nyata

```sql
-- find values that appear MORE THAN ONCE (duplicates)
SELECT email, COUNT(*) AS count
FROM users
GROUP BY email
HAVING COUNT(*) > 1;          -- groups with more than one row = duplicates
```

Kanggo *nggoleki* duplikat (dudu mung ngilangi dheweke), gunakake `GROUP BY` + `HAVING COUNT(*) > 1` — iki ngenali nilai-nilai endi sing dublemet lan pinten kali.

## DISTINCT banding GROUP BY

```sql
-- these are often equivalent for getting unique values:
SELECT DISTINCT country FROM users;
SELECT country FROM users GROUP BY country;
-- GROUP BY is more flexible (can add aggregates); DISTINCT is simpler for pure deduplication
```

## Cathetan ngenani performa

```text
DISTINCT requires the database to compare/sort rows to find uniques → can be costly
on large datasets. Often a sign you might restructure the query (e.g. a JOIN producing
duplicates that DISTINCT then removes — consider whether the JOIN is the issue).
```

## Ngapa iku penting

`DISTINCT` minangka fitur SQL sing migunani lan asring dibutuhake kanggo **nangani duplikat** — nggoleki nilai-nilai sing unik minangka kabutuhan sing asring ditugasake (kategori-kategori sing unik kanggo dropdown, entri-entri sing beda-beda, ngetung barang-barang sing unik), dadi mangerteni iku minangka kawruh praktis sehari-hari.

NgMangerteni carane `DISTINCT` makarya (ngilangi baris-baris duplikat, lan ing kolom-kolom liyane iku mbalekake kombinasi-kombinasi sing unik — titik ruwet sing asring), lan carane nggunakake `COUNT(DISTINCT)` kanggo ngetung nilai-nilai sing unik nutupi panggunaan-panggunaan sing lumrah.

Kayadene pentingé iku yaiku mangerteni carane **nggoleki duplikat nyata** (nggunakake `GROUP BY` + `HAVING COUNT(*) > 1`) — tugas sing asring lan penting kanggo pembersihan data lan validasi (ngenali email-email duplikat, rekam-rekam, lsp.).

Mangerteni hubungan antarane `DISTINCT` lan `GROUP BY` (asring padha para deduplikasi, karo GROUP BY sing luwih fleksibel) lan **cathetan performa** (DISTINCT butuh perbandhingan/penyortiran lan bisa dadi larang, lan kadhangkala nuduhake JOIN sing ngasilake duplikat sing ora dikarepake) uga migunani.
\_Merga nangani duplikat — sing ngilangi dheweke (DISTINCT) lan nggoleki dheweke (GROUP BY/HAVING) — minangka kabutuhan praktis sing asring ing panyuwunan lan karya kualitas data, lan merga mangerteni prilaku DISTINCT (utamane ing kolom-kolom liyane) lan pilihan-pilihan lengkaré pencegahan ruwet lan inefisiensi, mangerteni cara nangani duplikat nganggo DISTINCT minangka kawruh sing migunani lan asring diterapake kanggo makarya karo data nyata sing asring nglebokaké utawa mbutuhake nilai-nilai sing unik.