Get maximum number with combination of columns
If I'm understanding you correctly then the following should give you what you want.

  create table xt (name NVARCHAR(50) NULL, 
  city nvarchar(2) NULL,
  state nvarchar(2) NULL,
  country nvarchar(3) NULL)

  INSERT into xt (name, city, state, country)
  values(N'smith', N'ny', N'ny', N'usa'),
  (N'john', N'ny', N'ny', N'usa'),
  (N'john', N'nj', N'ny', N'usa')

SELECT name,
       city,
       state,
       ROW_NUMBER() OVER (PARTITION BY name ORDER BY (SELECT 0)) AS RN
  FROM xt
   GROUP BY name, city, state
   order by rn

drop table xt


This should provide the following output

name    city    state   RN
john    nj  ny  1
smith   ny  ny  1
john    ny  ny  2