Hi All,
I am writing a sql but running into issues. Below is the sample data that my table has 8 columns. All columns can have duplicate data. But i want all the records for which only column B should have different value, all other columns should have same value
for multiple records.
BOLD rows are the ones which i want.
Help please!!!
A B C D E F G H
4 3361683 007600652 NORA BRIGHAM N 115094 115116
4 3361683 007600652 NORA BRIGHAM N 115095 115255
4 3361683 007600652 NORA BRIGHAM N 115094 115255
1 7525493 007636745 SMOA GERALD N 125321 7005622
1 7525493 007636745 SMOA GERALD N 187986 7005622
1 7525493 007636745 SMOA GERALD N 187986 7000082
1 9748066 007677294 ECKEN ANIODE N 7045696 7050396
1 974 ...
Go to the complete details ...