165. Faqat birinchi ro'yxatdagilar
O'rtachaAdvancedmy.gov.uz
Ikkita tizim bor: eski va yangi. Ko'chirish paytida ba'zi yozuvlar
yangisiga o'tmay qolgan.
Eski tizimda bor, lekin yangisida yo'q pinfl larni toping.
Buni EXCEPT bilan yozing — u birinchi so'rovda bo'lib, ikkinchisida
bo'lmagan qatorlarni qaytaradi va takrorlarni ham olib tashlaydi.
Ustunlar: pinfl.
Saralash: pinfl o'sish.
old_system: id INT PK, pinfl VARCHAR
new_system: id INT PK, pinfl VARCHAR
Namuna ma'lumotlar
sample
old_system
| idINT | pinflVARCHAR(14) |
|---|---|
| 1 | 31234567890123 |
| 2 | 31234567890124 |
| 3 | 31234567890125 |
new_system
| idINT | pinflVARCHAR(14) |
|---|---|
| 1 | 31234567890123 |
| 2 | 31234567890125 |
Kutilgan natija
| pinfl |
|---|
| 31234567890124 |
sample-full
old_system
| idINT | pinflVARCHAR(14) |
|---|---|
| 1 | 31234567890123 |
| 2 | 31234567890124 |
| 3 | 31234567890125 |
| 4 | 31234567890126 |
| 5 | 31234567890127 |
| 6 | 31234567890123 |
| 7 | 31234567890128 |
| 8 | 31234567890129 |
| 9 | 31234567890130 |
| 10 | 31234567890131 |
new_system
| idINT | pinflVARCHAR(14) |
|---|---|
| 1 | 31234567890123 |
| 2 | 31234567890125 |
| 3 | 31234567890127 |
| 4 | 31234567890129 |
| 5 | 31234567890131 |
| 6 | 31234567890999 |
Kutilgan natija
| pinfl |
|---|
| 31234567890124 |
| 31234567890126 |
| 31234567890128 |
| 31234567890130 |
sample-extra
old_system
| idINT | pinflVARCHAR(14) |
|---|---|
| 1 | 32256404673778 |
| 2 | 32001157044926 |
| 3 | 33148482693298 |
new_system
| idINT | pinflVARCHAR(14) |
|---|---|
| 1 | 32316940549276 |
| 2 | 34183704723042 |
| 3 | 35984867090678 |
Kutilgan natija
| pinfl |
|---|
| 32001157044926 |
| 32256404673778 |
| 33148482693298 |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.