这个SQL语句怎么写？

[enjoynothing]

表： ID NAME ADDR
1 mary usa
1 mary usa
1 mary chn
1 mary chn
1 mary uk
1 mary uk
2 mike usa
2 mike usa
2 mike chn
2 mike chn
-----------------------------------------------------------------------
想变为：
1 mary usa
1 mary chn
1 mary uk
2 mary usa
2 mary chn

[zjcxc]

select ID,NAME,ADDR=min(ADDR) from 表 group by ID,NAME

[newdongkui]

select DISTINCT ID,NAME,ADDR from 表

[hjb111]

select * from yourtable group by id,name,addr

[hdslah]

select id,name,addr from 表名 group by id,name,addr

[pengdali]

select distinct * from 表名

[nboys]

select distinct ID,NAME,ADDR from tableName