Select

SUM(Case when field1='A' then 1 else 0) A,

SUM(Case when field1='A' then 1 else 0) B,

SUM(Case when field1='A' then 1 else 0) C

from table1

ethically now allowed.

IS there any distinct column in this table , or any auto generated value.

let me know?

if yes then this can be the solution

select * from dupilicate

where id in ( select min(id)...

Are you able to get this from one server , if yes then do this.

Make linked server , to all other server and then u can easily access that remote...

Please check the data type of these columns, it must be other than the date time. if no then let me know , so that we can find out some...

Select * from emp1 full outer join emp2 on emp1.empno=emp2.empno

where emp1.empno is null or emp2.empno is null