mySQL select one column DISTINCT, with corresponding other columns -

id   firstname   lastname 1      john        doe 2      bugs        bunny 3      john        johnson 

i want select distinct results firstname column, need corresponding id , lastname.

the result set needs show 1 john, id of 1 , lastname of doe.

try query

 select id, firstname, lastname table group by(firstname)