Need Help finding duplicates in SQL

[Bad_Student]

I have to get the ID if 2 or more IDs have the same a and b values

columns - ID, a, b

Data

ID 1,2,3,4,5

a 1,1,2, 0,0

b 1,2,3,1,1

Expecting output 

ID - 4,5 

 

Thanks

[niche]

Looks like ID 1 is the ID that has the same a/b values.

How does ID 4 & 5 qualify?

 

Edited October 18, 2019 by niche

[Sherin]

Try either of them

select t1.Id,t1.a,t1.b from Table1 t1 inner join 
(select a,b,count(*) as num from Table1  group by a,b having count(*)>1) t2 on t1.A=t2.A and t1.B=t2.b 

 

select t1.Id,t1.a,t1.b from Table1 t1 inner join 
(select a,b,ROW_NUMBER() OVER (PARTITION BY a,b ORDER BY a,b) as num from Table1 group by a,b having count(*)>1) t2 on t1.A=t2.A and t1.B=t2.b