MySQL select one column DISTINCT, with corresponding other columns May 30, 2022 by Tarik try this query SELECT ID, FirstName, LastName FROM table GROUP BY(FirstName)