Table with same row name in SQL Posted June 30, 2016 So given this table as a example Name, ID, RandomStuff Jon, 1, Blah Jon, 2, MoreBlah Tim, 4, EvenMoreBlah Bob, 12, HiThere Given that the table has rows with the same name but different IDs, how do you select the highest ID of the rows with the same name while still grabbing the rest of the table for display?
Table with same row name
in SQL
Posted
So given this table as a example
Name, ID, RandomStuff
Jon, 1, Blah
Jon, 2, MoreBlah
Tim, 4, EvenMoreBlah
Bob, 12, HiThere
Given that the table has rows with the same name but different IDs, how do you select the highest ID of the rows with the same name while still grabbing the rest of the table for display?