Table name = Contacts.
Table attributes = first_name,last_name,email_address,other_email,address,phone,notes.
I want to retrieve without repetition(DISTINCT) first_name and address. But, when retrieving these 2 data, i want all the other data(notes,last_name,etc..) associated to this the DISTINCT data to show.
Is there any SQL data for this kind of situation?