Posted on: 3/13/2015 10:59:06 PM | Views : 635

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 ...