Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


find duplicate entries in a column


find duplicate entries in a column  using -'I,am,writing,this,query,to,find,duplicate,CTN,Records,in,table1.,So,my,thinking,is,if,the,CTN_NO,appears,more,than,twice,or,higher,,,I,want,it,shown,in,my,SELECT,*,statement,output,on,top.

I,tried,the,following,sub-query,logic,but,I,need,pulls,

,,SELECT,*
,,,,,,,,,table1,
,,,WHERE,S_IND='Y'
,,,,,and,CTN_NO,=,(select,CTN_NO,
,,,,,,,,,,,,,,,,,,,,,from,table1,
,,,,,,,,,,,,,,,,,,,,where,S_IND='Y',
,,,,,,,,,,,,,,,,,,,,,,and,count(CTN_NO),<,2);
order,by,2'

asked Sep 24, 2015 by rolvyrf
edited Nov 18, 2015 by rajesh
0 votes
17 views



Related Hot Questions



Government Jobs Opening


...