Tell me more ×  I have a table with two columns, Name
(nvarchar(256)) and Score (int between 0 and 100). Each name can
have more than one score. I know it should be simple, but I
can't work out how to get one table containing each name only
once, and the top score for that name. Can anyone help?
share|improve this question Is Name actually a text datatype?,
if so, please stop using it, is deprecated already. You won't be
able to use it on a GROUP BY, ORDER BY, and many, many more
restrictions –  Lamak Jul 1 at 15:15 it's actually nvarchar
(just checked) Updating the op –  James Jul 1 at 15:18 What if
you have two people named James? How are you going to tell which
is which? Are you sure name is the column you want to group by?
–  Aaron Bertrand Jul 1 at 15:20 It's better to define a primary
key and then do group by... –  Zane Jul 1 at 15:22 In this case,
name is a uniquely assigned character string (Name is probably
not the right title for that column but I'm not in charge of
that), The answers given work, I