78. Takrorlangan email larni topish
O'rtachaImport faylida bir xil email bir necha marta uchragan.
CTE da takrorlangan email larni aniqlang, so'ng ularning barcha yozuvlarini
chiqaring.
Ustunlar: email, full_name, dup_count — bu email nechta yozuvda uchraydi.
Saralash: dup_count kamayish, keyin email alifbo, keyin full_name.
Jadval: contacts
| Ustun | Turi |
|---|---|
| id | INT PK |
| VARCHAR | |
| full_name | VARCHAR |
Namuna ma'lumotlar
sample
contacts
| idINT | emailVARCHAR(80) | full_nameVARCHAR(60) |
|---|---|---|
| 1 | aziz@mail.uz | Aziz K |
| 2 | aziz@mail.uz | Aziz Karimov |
| 3 | nilufar@mail.uz | Nilufar R |
Kutilgan natija
| dup_count | full_name | |
|---|---|---|
| aziz@mail.uz | 2 | Aziz K |
| aziz@mail.uz | 2 | Aziz Karimov |
sample-full
contacts
| idINT | emailVARCHAR(80) | full_nameVARCHAR(60) |
|---|---|---|
| 1 | aziz@mail.uz | Aziz K |
| 2 | aziz@mail.uz | Aziz Karimov |
| 3 | nilufar@mail.uz | Nilufar R |
| 4 | bekzod@mail.uz | Bekzod T |
| 5 | aziz@mail.uz | A. Karimov |
| 6 | bekzod@mail.uz | Bekzod Tursunov |
| 7 | malika@mail.uz | Malika Y |
| 8 | nilufar@mail.uz | N. Rahimova |
| 9 | sardor@mail.uz | Sardor N |
| 10 | jasur@mail.uz | Jasur Q |
| 11 | malika@mail.uz | Malika Yusupova |
| 12 | nilufar@mail.uz | Nilufar Rahimova |
Kutilgan natija
| dup_count | full_name | |
|---|---|---|
| aziz@mail.uz | 3 | A. Karimov |
| aziz@mail.uz | 3 | Aziz K |
| aziz@mail.uz | 3 | Aziz Karimov |
| nilufar@mail.uz | 3 | N. Rahimova |
| nilufar@mail.uz | 3 | Nilufar R |
| nilufar@mail.uz | 3 | Nilufar Rahimova |
| bekzod@mail.uz | 2 | Bekzod T |
| bekzod@mail.uz | 2 | Bekzod Tursunov |
| malika@mail.uz | 2 | Malika Y |
| malika@mail.uz | 2 | Malika Yusupova |
sample-extra
contacts
| idINT | emailVARCHAR(80) | full_nameVARCHAR(60) |
|---|---|---|
| 5 | sardor233@mail.uz | N. Rahimova |
| 4 | javohir379@mail.uz | Aziz Karimov |
| 3 | sardor233@mail.uz | A. Karimov |
| 2 | aziz892@mail.uz | Sardor N |
| 1 | islom264@mail.uz | Nilufar R |
Kutilgan natija
| dup_count | full_name | |
|---|---|---|
| sardor233@mail.uz | 2 | A. Karimov |
| sardor233@mail.uz | 2 | N. Rahimova |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.
