returns the full row for "highest" record of some sort

getMostRecentRecord.sql

CREATE TABLE link (
   ID serial PRIMARY KEY,
   name VARCHAR (255) NOT NULL,
   other VARCHAR (255) NOT NULL,
   score INT NOT NULL
);

INSERT INTO link (name, other, score)
VALUES
   ('Foo', 'ABC' , 13),
   ('Foo', 'DEF', 14),
   ('Baz', 'JKL', 12),
   ('Baz', 'MNO', 10)
   ;

SELECT i1.name, i1.other, i1.score AS "MAX SCORE"
FROM link AS i1 LEFT JOIN link AS i2
ON (i1.name = i2.name AND i1.score < i2.score)
WHERE i2.score IS NULL
;

http://sqlfiddle.com/#!9/7f4d4b/1/0