var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: problem with the query finding duplicates
HI everybody have this table with the following fields
locationID INT NULL,
locsjprov nvarchar(7) null,
addtype int null,
address1 nvarchar (255) null
the addtype has two values only which are 1 and 2 and some of the address1 values are duplicated.
I want to get all of the records that follow this criteria: Give me all the records that has duplicate address1 values but has different addtype.
with the query below it gets me all of the duplicates in address1 and not distinguish it with duplicates of address1 but different in addtype
FROM TEMP_TABLE2 AS S1
GROUP BY ADDRESS1
HAVING (COUNT(*)>1))AS S2
couldn't go further with this help!!
T1.addtype <> T2.addtype AND
hi thanks so much that did the trick....