Oracle between
来源:互联网 发布:社区网络延迟怎么解决 编辑:程序博客网 时间:2024/06/17 17:58
oracle between 使用简介
1.实验环境
Oracle Database 10g Enterprise Edition/SQL*Plus 10.2.0.4.0
2.
create table test_s
(
id number,
col2 date,
col3 varchar(10)
);
(
id number,
col2 date,
col3 varchar(10)
);
insert into test_s values(1,'20160920 23:00:00','2015-03-01');
insert into test_s values(2,'20160920 23:00:01','2015-03-02');
insert into test_s values(3,'20160920 23:00:02','2015-03-04');
insert into test_s values(4,'20160920 22:00:00','2015-03-04');
insert into test_s values(5,'20160920 22:02:00','2015-03-05');
insert into test_s values(11,'20160921 23:00:00','2015-04-02');
insert into test_s values(12,'20160921 23:00:01','2015-04-04');
insert into test_s values(13,'20160921 23:00:02','2015-04-05');
insert into test_s values(15,'20160921 22:02:00','2015-04-06');
insert into test_s values(14,'20160921 22:00:00','2015-04-07');
insert into test_s values(2,'20160920 23:00:01','2015-03-02');
insert into test_s values(3,'20160920 23:00:02','2015-03-04');
insert into test_s values(4,'20160920 22:00:00','2015-03-04');
insert into test_s values(5,'20160920 22:02:00','2015-03-05');
insert into test_s values(11,'20160921 23:00:00','2015-04-02');
insert into test_s values(12,'20160921 23:00:01','2015-04-04');
insert into test_s values(13,'20160921 23:00:02','2015-04-05');
insert into test_s values(15,'20160921 22:02:00','2015-04-06');
insert into test_s values(14,'20160921 22:00:00','2015-04-07');
select * from test_s;
select * from test_s where id between 2 and 12 order by 1;
select * from test_s where col2 between '20160920 23:00:00' and '20160921 23:00:00' order by 2;
select * from test_s where col2 between '20160920 23:00:00' and '20160921 23:00:01' order by 2;
select * from test_s where col3 between '2015-03-01' and '2015-04-02' order by 3;
3.结论
对于 number,varchar,date 数据类型 between 是左右全闭区间
0 0
- Oracle between
- between [Oracle SQL]
- Oracle BETWEEN 条件
- oracle 中BETWEEN命令
- oracle between and 边界问题
- oracle中的between使用
- Oracle between and 边界问题
- oracle sql分组,between,in
- oracle 不要乱用between and
- Between
- Oracle-The Main Difference Between DELETE & TRUNCATE
- oracle between and 的简单条件查询
- 【转载】关于 oracle between and的用法!
- 关于 oracle between and的用法!
- oracle 的日期 between and 用法
- compatibilities between Oracle database servers and clients
- the difference between Oracle and Mysql
- The difference between EXISTS and IN upon Oracle
- QtWidget中各个主流系统宏区分
- Android NDK学习笔记8-JNI的访问域
- Android studio代码提示设置
- Maven仓库搭建(一):一台HTTP服务器即可(Tomcat、Apache或Nginx)
- 英文文字游戏(二)
- Oracle between
- MySQL 查看数据库中有主外键关系的表信息
- Real time system
- 编写线程安全的Java代码
- Retrofit中如何正确的使用https?
- SQL Server 2008 标准版安装失败:操作系统不匹配
- Pentium的相关知识
- Linux下安装Memcache以及安装过程中一些问题的解决方法
- 移动端开发所需要的一些资源与小技巧