oracle 语句联系
来源:互联网 发布:经纬度数据库 编辑:程序博客网 时间:2024/06/05 14:23
create table test
(
tid Number(10,0) not null primary key,
col1 varchar2(10) ,
col2 varchar2(10) ,
col3 varchar2(10) ,
col4 varchar2(10)
);
insert into test values(1,'a','aa','aaa','1');
insert into test values(2,'a','aa','aaa','3');
insert into test values(3,'b','bb','bbb','4');
insert into test values(4,'b','bb','bbb','0');
insert into test values(5,'c','cc','ccc','1');
insert into test values(6,'c','cc','ccc','2');
insert into test values(7,'d','dd','ddd','0');
insert into test values(8,'a1','aa1','aaa1','3');
insert into test values(9,'a2','aa2','aaa2','2');
insert into test values(10,'a3','aa3','aaa3','1');
select * from test t
where exists(select 1 from test t2
where t.col1=t2.col1
and t.col2=t2.col2
and t.col3=t2.col3
and t.col4>t2.col4)
(
tid Number(10,0) not null primary key,
col1 varchar2(10) ,
col2 varchar2(10) ,
col3 varchar2(10) ,
col4 varchar2(10)
);
insert into test values(1,'a','aa','aaa','1');
insert into test values(2,'a','aa','aaa','3');
insert into test values(3,'b','bb','bbb','4');
insert into test values(4,'b','bb','bbb','0');
insert into test values(5,'c','cc','ccc','1');
insert into test values(6,'c','cc','ccc','2');
insert into test values(7,'d','dd','ddd','0');
insert into test values(8,'a1','aa1','aaa1','3');
insert into test values(9,'a2','aa2','aaa2','2');
insert into test values(10,'a3','aa3','aaa3','1');
select * from test t
where exists(select 1 from test t2
where t.col1=t2.col1
and t.col2=t2.col2
and t.col3=t2.col3
and t.col4>t2.col4)
- oracle 语句联系
- sql查询语句联系
- MySQL / SQL Server / Oracle / MS Access的sql语句联系区别总结
- MySQL / SQL Server / Oracle / MS Access的sql语句联系区别总结
- 关于c#.net oracle 中联系执行多条sql语句的问题
- sql语句联合及联系
- oracle语句
- oracle 语句
- oracle 语句
- Oracle语句
- ORacle语句
- oracle 语句
- oracle 语句
- ORACLE语句
- oracle语句
- oracle-语句
- Oracle语句
- Oracle 条件语句/循环语句
- protlet-ext
- java获得日期
- vi 详解
- Spring AOP介绍
- Multi-Level Drop Down Menu (多层下拉菜单)
- oracle 语句联系
- js图片幻灯片模式切换代码
- Flex编译器以及常用编译参数
- PHP 图片上传,添加字符串水印,添加图片(指定四个角) 图片压缩
- 企业应从功能出发为ERP系统选型(一)
- 对mysql列的操作
- 大数相乘
- WSAEventSelect模型
- 在CentOS6虚拟机上安装VirtualBox增强功能