sql - How to find The Same City and same salary record

Question

i want to find multi same city and same salary record by using temp table

Answer 1

declare @t table
    (
     City nvarchar(20),
     Salary decimal(9, 2)
    )

insert  into @t
        (City, Salary)
values  (N'New York', 65000),
        (N'London', 68000),
        (N'Sydney', 59000),
        (N'Sydney', 59000),
        (N'Tokyo', 66000)

select  *
from    @t as t
group by t.City,
        t.Salary
having  count(1) > 1