Need Help finding duplicates in SQL in SQL Posted October 10, 2019 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
Need Help finding duplicates in SQL
in SQL
Posted
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