Thread: Find duplicate entries in a table?
View Single Post
  #4 (permalink)  
Old 05-07-2006, 11:06 PM
Rob137
 
Posts: n/a
Default MS SQL answer. Re: Find duplicate entries in a table?
[sql]
select *
from Something as zd
where (select count(*) from Something as t1
where = zd.liefschnum and t1.pos = zd.pos) > 1
[/sql]
Edit/Delete Message Reply With Quote