MySQL select one column DISTINCT, with corresponding other columns

ghz 1years ago ⋅ 8269 views

Question

ID   FirstName   LastName
1      John        Doe
2      Bugs        Bunny
3      John        Johnson

I want to select DISTINCT results from the FirstName column, but I need the corresponding ID and LastName.

The result set needs to show only one John, but with an ID of 1 and a LastName of Doe.


Answer

try this query

 SELECT ID, FirstName, LastName FROM table GROUP BY(FirstName)