ID kalitiga asoslangan yuklangan ikkinchi oldingi yozuvni yozishingiz kerak: |id |msisdn |tarif_plan_id|account_id|raw_dt | |------------|-----------|-------------|----------|-----------| |[phone]|5842 |4979 |[phone]| |[phone]|4563 |0832 |[phone]| |[phone]|4563 |0832 |[phone]| Abonentlar uchun o'zgarishlar tarixiga ega jadval mavjud. Har bir yozuv abonent uchun valid_from_dt dan valid_to_dt gacha amal qiladi. Agar yozuv yopilsa, keyingi yozuv ayni sanada boshlanadi. Har bir abonent uchun faqat bitta faol yozuv bo'lishi kerak [valid_from_dt, valid_to_dt] oralig'ida. select * from abnt |id|valid_from_dt|valid_to_dt|msisdn |tarif_plan_id|account_id| |--|-------------|-----------|-------------|-------------|----------| |1 |[phone] |[phone] |[phone] |4375 |4979 | |1 |[phone] |[phone] |[phone] |5842 |4979 | |2 |[phone] |[phone] |[phone] |4563 |5326 | |2 |[phone] |[phone] |[phone] |4563 |0832 | Haqiqatan ham noto'g'ri yopilish sanasi bo'lgan yozuvlarni qaytaradigan so'rov yozishingiz kerak. |id|valid_from_dt|valid_to_dt|msisdn |tarif_plan_id|account_id| |--|-------------|-----------|-------------|-------------|----------| |1 |[phone] |[phone] |[phone] |5842 |4979 | |2 |[phone] |[phone] |[phone] |4563 |5326 |