DISTINCT huondoa safu zinazojirudia kutoka matokeo, ikirudisha tu thamani za kipekee. Inatumika kupata thamani za kipekee za safuwima (au mchanganyiko wa safuwima) — ya kawaida kwa kupata maingizo ya kipekee au kujenga orodha za dropdown.
country users;
country, city users;
DISTINCT hutumika kwa safuwima zote zilizochaguliwa kwa pamoja — DISTINCT country, city hurudisha michanganyiko ya kipekee, si nchi za kipekee na miji ya kipekee kivyao.
-- 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) huhesabu thamani za kipekee — yenye manufaa kwa "kuna X tofauti ngapi?"
-- 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
Kupata nakala-zinazojirudia (si kuziondoa tu), tumia GROUP BY + HAVING COUNT(*) > 1 — hii hutambua thamani zipi zinajirudia na mara ngapi.
-- 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
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).
DISTINCT ni kipengele cha SQL chenye manufaa, kinachohitajika mara kwa mara kwa kushughulikia nakala-zinazojirudia — kupata thamani za kipekee ni hitaji la mara kwa mara (kategoria za kipekee kwa dropdown, maingizo tofauti, kuhesabu vitu vya kipekee), hivyo kukielewa ni maarifa ya kivitendo ya kila siku.
Kujua jinsi DISTINCT inavyofanya kazi (kuondoa safu zinazojirudia, na kwamba kwenye safuwima nyingi hurudisha michanganyiko ya kipekee — hoja ya kawaida ya mkanganyiko) na jinsi ya kutumia COUNT(DISTINCT) kwa kuhesabu thamani za kipekee hufunika matumizi ya kawaida.
Ni cha thamani vivyo hivyo kujua jinsi ya kupata nakala halisi zinazojirudia (kwa kutumia GROUP BY + HAVING COUNT(*) > 1) — kazi ya kawaida, muhimu kwa usafishaji na uthibitishaji wa data (kutambua barua pepe, rekodi zinazojirudia, n.k.).
Kuelewa uhusiano kati ya DISTINCT na GROUP BY (mara nyingi sawa kwa deduplication, ikiwa GROUP BY ni rahisi zaidi kubadilika) na dokezo la utendaji (DISTINCT inahitaji kulinganisha/kupanga na inaweza kuwa ya gharama, na wakati mwingine huashiria JOIN inayozalisha nakala zisizohitajika) pia ni cha manufaa.
Kwa kuwa kushughulikia nakala-zinazojirudia — kuziondoa (DISTINCT) na kuzipata (GROUP BY/HAVING) — ni hitaji la kawaida la kivitendo katika uulizaji na kazi ya ubora wa data, na kwa kuwa kuelewa tabia ya DISTINCT (hasa kwenye safuwima nyingi) na njia zake mbadala huzuia mkanganyiko na ukosefu wa ufanisi, kujua jinsi ya kushughulikia nakala-zinazojirudia kwa DISTINCT ni maarifa yenye manufaa, yanayotumika mara kwa mara kwa kufanya kazi na data halisi ambayo mara nyingi huwa na au inahitaji thamani za kipekee.
Maktaba ya maswali ya mahojiano ya IT yenye majibu ya kina — kutoka Junior hadi Senior.
Changia