现有一表，里面有多个重复的纪录，如
a b
1 A
1 A
2 B
2 B
我现在要的是
1 A
2 B
就是把重复的去掉，请各位大侠指教！
------解决方案--------------------
- SQL code
select distinct t.a,t.bfrom (select '1' as a,'A' as b from dualunion allselect '1','A' from dualunion allselect '2','B' from dualunion allselect '2','B' from dual )t-------------------------------- A B1 1 A2 2 B