MAX Value

DECLARE @TableX TABLE
(id tinyint,
 name varchar(12),
 item tinyint,
 RowNumbers tinyint)

INSERT INTO @TableX
VALUES
 (5, 'bob', 111, 3),
 (4, 'sam', 111, 3),
 (3, 'smith', 111, 3),
 (2, 'sammy', 111, 1),
 (5, 'bob', 111, 2)

SELECT * FROM @TableX
WHERE RowNumbers = (SELECT MAX(RowNumbers) FROM @TableX)

---

If there was a problem - Yo, I'll solve it