between 2004-10-11 and 2004-12-22
解决方案 »
- 移动加权平均法的SQL,大家看看如何来写?
- SQL SERVER 汇总问题
- 求助啊啊啊啊啊啊~~~~~
- An error has occurred while establishing a connection to the server. When connec
- 存储过程一问!
- 求(intl类型格式化)sql语句。
- 执行CHECKDB后发现的错误该如何解决?
- 我用vb在单机上编一个程序,使用的数据大概有300m左右,用什么样的数据库比较好,谢谢
- 用MS-Anlysis时说找不到数据挖掘算法是怎么回事啊?
- 请问有没有好的SQL语句的文本编辑器?
- 为什么我下载安装mysql-4.1.8后,在命令行下进入mysql\bin下,运行mysqld-nt --install,正常。再开启mysql服务运行net start mysql就报错
- 初学sql server,请教关于OSQL的问题!多谢!
(select * from [200410]
union all
select * from [200411]
union all
select * from [200412])
where
采样时间 between cast('2004-10-11' as datetime) and cast('2004-12-22' as datetime)
(select * from [200410]
union all
select * from [200411]
union all
select * from [200412]) a
where
a.采样时间 between cast('2004-10-11' as datetime) and cast('2004-12-22' as datetime)
select * from(
select * from [200409]
union all
select * from [200410]
union all
select * from [200411]
union all
select * from [200412]) a
where 采样时间 between '2004-10-11' and '2004-12-22'删除重复就用: union
where 采样时间 between 2004-10-11 and 2004-12-22
union
select * from t2
where 采样时间 between 2004-10-11 and 2004-12-22
...
create view vi_test
as
select * from [200409]
union all
select * from [200410]
union all
select * from [200411]
union all
select * from [200412]go--then
select * from vi_test where 条件
happydreamer(小黑) 、libin_ftsafe(子陌红尘) 你们都很棒!!!