DBMS: SQL Server 2014;
Problem: I need to know which records are duplicated, so that the verification is done in two simultaneous fields, ie if the field "CPF" with the value '83971465842' and the field 'MAT' with the value ' 001 'exists, in an identical fashion, in another tuple. As shown in the example below:
CPF MAT
83971465842 001
83971465842 001
57650942287 111
57655707200 305
57656959220 916
57656959220 209
Note that in the first two records, the values '83971465842' + '001' are on two different lines. These are precisely the ones I need to identify. How to make the query?