SQL DATETIME字段比较
比如有个表其中有3个datetime字段，一般来说其中有个datetime字段的值会比其他2个大（修改后日期），那怎么找出这条记录？
來數據說明吧
...........
select * from TB where dt1>dt2 and dt1>dt3
union all
select * from TB where dt2>dt1 and dt2>dt3
union all
select * from TB where dt3>dt1 and dt3>dt1
比较两个日期的差：
用 datediff()
SQL code:
select * from TB where dt1>dt2 and dt1>dt3
union all
select * from TB where dt2>dt1 and dt2>dt3
union all
select * from TB where dt3>dt1 and dt3>dt1
找出记录还是找出字段?
DATEDIFF ( datepart , startdate , enddate )
SQL code:
create table #test
(dt1 datetime,
dt2 datetime,
dt3 datetime)
insert #test
select '20100110','20091221','20121212' union all
select '20091221','20121212','20100110' union all
select '20121212','20091221','20100110'
select
case when dt1>dt2 and dt1>dt3 then dt1 else null end,
case when dt2>dt1 and dt2>dt3 then dt2 else null end,
case when dt3>dt2 and dt3>dt1 then dt3 else null end
from #test
相关问答：
从数据库中查询一张表的数据
select 部门,姓名 from tb
如何才能生成下面的xml格式
XML code:
<folder state="unchecked" label="全部">
<folder state="unchecked&qu ......
我是在toad中输入下段sql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
表
id bh
1 10
2 11
3 12
4 15
5 16
6 22
7 25
8 26
9 27
10 28
将bh按连续分段出来返回字符串：
10~12，15~16，22，25~28
SQL code:
declare @t tabl ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
上面一个简单的SQL,执行时间2.6� ......
第一句:
select ht.gfdm,gfdm.gfmc,gfdm.lb ,sum(jh.htdj*jh.htsl)as je
from ht left join gfdm on ht.gfdm=gfdm.gfdm
join jh on ht.htbh=jh.hth
and ht.htbh not like'del%' and ht. ......
