[Solved] how to select duplicate record as one record in mysql

You have to concatenate the two fields, and pass them together to the group by
as following

select 
 id, 
 concat(`field1`,`field2`) as `together` 
from table_name 
group by together