Eliminating Records from a Query based on a Condition 1

[LeonelSanchezJr]

If the query returns 3 records for the same Document #, then I want to keep the 3 records in the result set.

However, if the query returns less than 3 records for the
same Document #, then I want to delete the records from my result set (which is in a Temp Table). B-)

DOCUMENT# DOCTYPE
1234567 ABC
1234567 DEF
1234567 GHI

 

[dbmsguy]

if i am reading this correctly, what you have is a temp table and you want to delete all occurances if the same doc# occurs less than 3 times (ie. 1 or 2 times)

therefore you could

delete from #temp where doc# in (select distinct doc# from #temp group by doc# having count(*) < 3)

you might try something like this Paul

http://www.dbmsguy.com