Thank you, OPC.THREE
create table T1(
SL int NOT NULL IDENTITY (1, 1),
ISDN varchar(13) NULL,
MSG varchar(50) NULL
)
insert into T1(ISDN,MSG) values ('123','ABC');
insert into T1(ISDN,MSG) values ('123','ABC');
insert into T1(ISDN,MSG) values ('123','XYZ');
insert into T1(ISDN,MSG) values ('124','XYZ');
insert into T1(ISDN,MSG) values ('124','EFG');
Now I wanna compare whether there is any similar row comprising ISDN and MSG columns.