Duplicate rows - Ignore

M, Murugeswari (Cognizant) 456 Reputation points
2022-02-25T16:36:22.457+00:00

Hi,

I have 6 columns. Lets consider the column names as A,B,C,D,E,F. If all the first four column (A,B,C,D) values are same, then we consider it as duplicates. We need to load the data only if atleast any of the first four column values does not have the same value. Is there any way

For example, the below is consider as duplicate and I want to avoid that

177926-image.png

Thanks

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,565 questions
{count} votes

0 additional answers

Sort by: Most helpful