Select Only Multiple Rows

I have a table that contains the same values ​​in all its columns.

What I want to do in this SQL table is to select rows containing the same values ​​in columns A and B during selection.

I want a query that will output the following

>Solution :

You need GROUP BY and HAVING:

SELECT t.Name, t.Number, COUNT(*) AS Count
FROM dbo.YourTable AS t
GROUP BY t.Name, t.Number
HAVING COUNT(*) > 1;

Example on db<>fiddle