Selective Deduping

[mindbender]

I have a table with duplicate row ids that I would like to dedup. However I would like to keep a specific record if it exists as a duplicate.

An example of the data is below. Basically keep the row with an Equipment Type of Device and remove the other as a duplicate. I can't just remove the rows with a value of Demonstration Room as there are instances where that is the value and it is not a duplicated row id.

Any help would be appreciated

Booking ID	Equipment Type
10163	Demonstration Room	This would be removed as part of the deduping process
10163	Device	This one would be kept because there is an Equipment type of Device

[aytee111]

See if this does what you need:

http://allenbrowne.com/subquery-01.html

[mindbender]

See if this does what you need:

http://allenbrowne.com/subquery-01.html

You have come through once again Aytee111

I really appreciate it