ORACLE 分组查询

Question

题：
表结构：
----------------------------------------------------------
id         code            name
--------------------------------------------------------
1            1              张三
1            1              李四
1            2              王五
1            2              孙六
2            1               张七
----------------------------------------------------
结果
---------------------------------------------
id           code
-----------------------------------------
1             1
1             2
2             1
-------------------------------------------请问sql语句 如何实现？

Answer 1

select distinct id code from table