Member Avatar for TJR
TJR 0 Newbie Poster

I have 2 tables, a table with header records and a table with detail records. If I run the following, I am shown that I have 96 duplicate rows.

select item_id,count(*)
from in_qty_price_bracket_hdr
where item_id is not null
group by item_id
having count(*) > 1

The item_id field is not the primary key ... is the guid for the item number. The primary key for this table is unique for every row. In other words, it is the item number that is duplicated. My objective is to delete one of the two rows for each of the 96 items that are duplicated. Because the two tables are related, I would need to identify the rows in the detail record table that are attached to the lines in the header table I intend to ... or want to delete.

Will confess I am fairly new at this and coming up the learning curve, but if someone were able to offer some advice and/or sample scripts on how to go about this, would be much appreciated.

  • 1 Contributor
  • 0 Replies
  • 50 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.