相当于执行
select *
from JSZBRWZZB a
where not exists (select 1 from JSZBRWZZB b where b.ZZRQ>a.ZZRQ)
select *
from JSZBRWZZB a
where not exists (select 1 from JSZBRWZZB b where b.ZZRQ>a.ZZRQ)
解决方案 »
- datetime数据类型的烦恼???
- DataAdapter与SqlCommand都可以将数据查询出来,有什么区别吗?
- id自動加1,標題想要遞增到10000,使用sqlite语法..请问咋写呢?
- 各位帮我看一下,这个SQL语句哪里错了?
- 'set nocount on' 是干什么用的啊?
- ★★★我急!我急!分组的高难度问题,高手请进,解决必给分!!!
- 如何不用临时表而分页显示数据~~~???
- 在线等待!凡回答者都有分!!!
- 如何将主键表中的记录删除之后,外建表中的相应记录都删除?
- sqlserver 如何查找一个字符串包含几个另外一个字符串
- 求一Update语句.
- 求助!服务器使用sql2008,在不同网络环境下有的可以连上。有的连接被拒绝连不上。网上所有方法看了都没解决,找不到原因!不知道网络原因还是配置有问题还是计算机
select top 1 '9999-01-01' as XZSJ from JSZBRWXZCB xz where xz.ZBID=zz.ZBID and (xz.XZSJ is null or xz.XZSJ='')
UNION
select top 1 XZSJ from JSZBRWXZCB xz where xz.ZBID=zz.ZBID order by XZSJ desc) a)得到的不应该是‘9999-01-01’吗?为什么会是null?
isnull 函数 你默认0 比较试试
select zz.* from (select * from JSZBRWZZB a where not exists (select 1 from JSZBRWZZB b where b.ZZRQ>a.ZZRQ)) zz
where ZZRQ > isnull((
select top 1 XZSJ from (
select top 1 '9999-01-01' as XZSJ from JSZBRWXZCB xz where xz.ZBID=zz.ZBID and (xz.XZSJ is null or xz.XZSJ='')
UNION
select top 1 XZSJ from JSZBRWXZCB xz where xz.ZBID=zz.ZBID order by XZSJ desc) a)
,0)
select top 1 XZSJ
from (
select top 1 '9999-01-01' as XZSJ
from @JSZBRWXZCB xz
where xz.ZBID=zz.ZBID and (xz.XZSJ is null or xz.XZSJ='')
UNION
select top 1 XZSJ
from @JSZBRWXZCB xz
where xz.ZBID=zz.ZBID order by XZSJ desc) a order by XZSJ desc ) ,'')
排序问题
select top 1 XZSJ
from (
select top 1 '9999-01-01' as XZSJ
from @JSZBRWXZCB xz
where xz.ZBID=zz.ZBID and (xz.XZSJ is null or xz.XZSJ='')
UNION
select top 1 XZSJ
from @JSZBRWXZCB xz
where xz.ZBID=zz.ZBID order by XZSJ desc) a order by case XZSJ when null then '1900-01-01' else XZSJ end desc ) ,'')