现有表结构
create table abc (A char(2),B char(2),C char(2))
插入数据
insert abc values("a1","b1","c1")
insert abc values("a1","b1","c2")
insert abc values("a2","b2","c1")
insert abc values("a2","b2","c2")
insert abc values("a3","b3","c2")
insert abc values("a3","b3","c2")
现想获得数据
a1,b1
a2,b2
a3,b3
即过滤掉前两字段的重复值,请问sql语句改怎么写
create table abc (A char(2),B char(2),C char(2))
插入数据
insert abc values("a1","b1","c1")
insert abc values("a1","b1","c2")
insert abc values("a2","b2","c1")
insert abc values("a2","b2","c2")
insert abc values("a3","b3","c2")
insert abc values("a3","b3","c2")
现想获得数据
a1,b1
a2,b2
a3,b3
即过滤掉前两字段的重复值,请问sql语句改怎么写
解决方案 »
- 请教下数据库时间点恢复的问题
- oracle 数据库,监听停了以后,直接就shutdown immediate,然后 数据库的服务器就再连不上了
- 谁有http://www.oracle.com.cn/的注册邀请码
- 启动数据库时报错ora-16068
- ORACLE 创建存储过程
- 在VC中配置ProC开发环境
- 【请问】package.procedure 与procedure在运行效率上有什么区别
- Oracle中有没有象SQL Sever 2000中附加数据库的功能
- select to_char(visit_date,'yyyyMMdd') || to_char(visit_no,'00000')
- 单行子查询返回多个行,求大神指点
- 你一定能够解决oracle
- 用语句怎么修改一个列的长度?
即可
是过滤掉a重复,这样范围就缩小了
insert abc values("a1","b1","c1")
insert abc values("a1","b1","c2")
insert abc values("a2","b2","c1")
insert abc values("a2","b2","c2")
insert abc values("a3","b3","c2")
insert abc values("a3","b3","c2")
再加一条
insert abc values("a2","b3","c2")
那么应该显示
a1,b1
a2,b2
a2,b3
a3,b3
a1,b1
a2,b2
a2,b3
a3,b3
难道这有什么不对吗?