67. Takroriy yozuvlarni tozalash
O'rtachaImport paytida bir xil email bilan bir nechta yozuv tushib qolgan.
Har bir email uchun faqat bittasini qoldiring — created_at bo'yicha
eng yangi yozuv. Sana ham teng bo'lsa id kattaroq bo'lgani qolsin.
Ustunlar: id, email, full_name, created_at.
Saralash: email alifbo.
Jadval: contacts
| Ustun | Turi |
|---|---|
| id | INT PK |
| VARCHAR | |
| full_name | VARCHAR |
| created_at | DATE |
Namuna ma'lumotlar
sample-basic
contacts
| idINT | emailVARCHAR(80) | full_nameVARCHAR(60) | created_atDATE |
|---|---|---|---|
| 1 | aziz@mail.uz | Aziz K | 2025-01-10 |
| 2 | aziz@mail.uz | Aziz Karimov | 2025-03-05 |
| 3 | bek@mail.uz | Bek T | 2025-01-15 |
Kutilgan natija
| id | full_name | created_at | |
|---|---|---|---|
| 2 | aziz@mail.uz | Aziz Karimov | 2025-03-05 |
| 3 | bek@mail.uz | Bek T | 2025-01-15 |
sample-single
contacts
| idINT | emailVARCHAR(80) | full_nameVARCHAR(60) | created_atDATE |
|---|---|---|---|
| 1 | solo@mail.uz | Solo | 2025-02-01 |
Kutilgan natija
| id | full_name | created_at | |
|---|---|---|---|
| 1 | solo@mail.uz | Solo | 2025-02-01 |
sample-same-date
contacts
| idINT | emailVARCHAR(80) | full_nameVARCHAR(60) | created_atDATE |
|---|---|---|---|
| 1 | x@mail.uz | Eski | 2025-05-01 |
| 2 | x@mail.uz | Yangi | 2025-05-01 |
Kutilgan natija
| id | full_name | created_at | |
|---|---|---|---|
| 2 | x@mail.uz | Yangi | 2025-05-01 |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.