need help for distinct in MYSQL

[Anon]

I need to select unique in field
email and name in order
email is first
name is second
how can i write sql?

select distinct email,name from table

it's not right, i found email is still duplicate .

help me please

[Anon]

try:
select email,name from table group by email

to get your desired effect.