MySQL select one column DISTINCT, with corresponding other columns

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 1

try this query

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