Tuesday, January 28, 2014

Deduping rows in Netezza / Deleting rows in Netezza.

netezza has a hidden rowid for every row in all tables. to dedup, you can do this:

delete from omszip_stage
where rowid in (
select  max(rowid) as rowid
from OMSZIP_STAGE
group by couponid, zip, pid
having count(*) > 1)


Posted by at
Labels:

21 comments:

  1. partimerMarch 12, 2014 at 10:22 AM

    rowid is a hidden column in all netezza tables

    ReplyDelete
  2. 21st Century Software SolutionsMarch 20, 2014 at 1:43 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  3. AnonymousApril 16, 2014 at 12:23 AM

    My favorite query for finding/deleting duplicates is using rowid:

    select *
    --delete
    from table_with_duplicate t_remove_this
    where exists (select 1 from table_with_duplicate t_keep_this
    where t_remove_this.keyfield1 = t_keep_this.keyfield1
    and t_remove_this.keyfield2 = t_keep_this.keyfield2
    and t_remove_this.keyfield3 = t_keep_this.keyfield3
    and t_remove_this.keyfield1.rowid > t_keep_this.rowid)

    ReplyDelete
    Replies
    1. AnonymousApril 16, 2014 at 12:25 AM

      last line must be
      and t_remove_this.rowid > t_keep_this.rowid)

      Delete
  4. 21st Century Software SolutionsMay 12, 2014 at 2:39 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  5. UnknownJuly 11, 2014 at 12:35 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  6. The TukkieMarch 4, 2020 at 10:49 PM

    Thanks gracious!!

    ReplyDelete
  7. helinAugust 18, 2023 at 4:48 PM

    kuşadası
    milas
    çeşme
    bağcılar
    siirt

    ZUC5

    ReplyDelete
  8. PlasmaWizard666October 7, 2023 at 1:42 AM

    kars
    sinop
    sakarya
    ankara
    çorum
    RALTX3

    ReplyDelete
  9. Yüce5October 8, 2023 at 9:31 PM

    whatsapp görüntülü show
    ücretli.show
    İUNV

    ReplyDelete
  10. 5C81EJanessa45727November 10, 2023 at 2:06 AM

    2D8C1
    Edirne Evden Eve Nakliyat
    Çerkezköy Halı Yıkama
    Bartın Parça Eşya Taşıma
    Giresun Lojistik
    Çerkezköy Çelik Kapı
    Denizli Şehir İçi Nakliyat
    Trabzon Parça Eşya Taşıma
    Niğde Şehir İçi Nakliyat
    Paribu Güvenilir mi

    ReplyDelete
  11. 7BA3AJerome420E6December 22, 2023 at 5:09 PM

    8D5BB
    niğde kızlarla canlı sohbet
    isparta bedava sohbet uygulamaları
    çorum rastgele canlı sohbet
    bilecik sesli mobil sohbet
    muğla muhabbet sohbet
    adıyaman ücretsiz sohbet odaları
    bayburt canlı sohbet bedava
    şırnak sohbet siteleri
    yabancı görüntülü sohbet uygulamaları

    ReplyDelete
  12. 2D7DBVictoria0B435December 26, 2023 at 1:52 PM

    8834D
    denizli telefonda kızlarla sohbet
    bartın ücretsiz sohbet odaları
    sohbet
    elazığ rastgele görüntülü sohbet
    Ağrı Random Görüntülü Sohbet
    mobil sohbet siteleri
    Kırklareli Sesli Sohbet Mobil
    niğde sesli sohbet mobil
    çanakkale canlı sohbet et

    ReplyDelete
  13. 55FF3LindsayA7C9EJanuary 19, 2024 at 11:27 PM

    95042
    Dxy Coin Hangi Borsada
    Bulut Madenciliği Nedir
    Spotify Dinlenme Satın Al
    Kripto Para Madenciliği Nedir
    Görüntülü Sohbet
    Kripto Para Üretme
    Sohbet
    Clubhouse Takipçi Hilesi
    Coin Oynama

    ReplyDelete
  14. AnonymousOctober 5, 2024 at 10:15 PM

    Respect and that i have a keen offer: Who Repairs House Windows Near Me complete house renovation cost

    ReplyDelete
  15. 3FF2879931Aaron0BB3BF8D73January 1, 2025 at 11:22 AM

    7B181425BC
    instagram takipçi alma

    ReplyDelete
  16. 18156DB4E5Alan694C6FC1E3January 1, 2025 at 11:22 AM

    A19C0C2DCF
    takipci atma

    ReplyDelete
  17. 1B0E05F248Kevin72E05608F0January 2, 2025 at 1:47 AM

    9C1400A61D
    instagram bot takipci satin al

    ReplyDelete
  18. B2051D0BFBRylee10B0165452January 2, 2025 at 9:20 AM

    894ADA1C7F
    twitter takipci al

    ReplyDelete
  19. 895318B739Anthony5EC6DC3538January 2, 2025 at 12:02 PM

    3BF34600FB
    instagram takipci organik

    ReplyDelete
  20. AnonymousFebruary 4, 2025 at 11:02 PM

    4C72668004
    ucuz takipçi satın al
    Pokemon GO Promosyon Kodu
    MLBB Hediye Kodu
    War Robots Hediye Kodu
    Azar Elmas Kodu
    Whiteout Survival Hediye Kodu
    Danone Sürpriz Kodları
    Avast Etkinleştirme Kodu
    Bitcoin En Güvenilir Nereden Alınır

    ReplyDelete

Subscribe to: Post Comments (Atom)