这个查询只能有一个值
(select convert(varchar(8),b.c_senddate,112) from csrk.dbo.tab_csz as b where c.cb_birthno=b.c_sendcard) as CARD_TIME看语句的意思,应该是查一个时间,你可以设定要查最大时间
(select convert(varchar(8),MAX(b.c_senddate),112) from csrk.dbo.tab_csz as b where c.cb_birthno=b.c_sendcard) as CARD_TIME
或最小时间
(select convert(varchar(8),MIN(b.c_senddate),112) from csrk.dbo.tab_csz as b where c.cb_birthno=b.c_sendcard) as CARD_TIME
这样子查询就确保只有一个了
(select convert(varchar(8),b.c_senddate,112) from csrk.dbo.tab_csz as b where c.cb_birthno=b.c_sendcard) as CARD_TIME看语句的意思,应该是查一个时间,你可以设定要查最大时间
(select convert(varchar(8),MAX(b.c_senddate),112) from csrk.dbo.tab_csz as b where c.cb_birthno=b.c_sendcard) as CARD_TIME
或最小时间
(select convert(varchar(8),MIN(b.c_senddate),112) from csrk.dbo.tab_csz as b where c.cb_birthno=b.c_sendcard) as CARD_TIME
这样子查询就确保只有一个了
解决方案 »
- sql server 2005 如何对多字段进行模糊查询
- 关于这个帖子的新的办法。。
- 用游标取数据(大多数情况下不超过5条),这样对性能影响大吗?
- 求一简单的sql语句
- 汇总求和,求帮忙
- 俺注册了两个服务器 ! 问题来了.
- select max(字段)from 表 的问题?非常奇怪,不可不看!求救!
- 太不可思议了:内存表竟然比永久表慢12倍以上???SQL Server怎样优化的?
- 请教怎么恢复SQL SERVER数据库
- 不能连接到 SQL Server 2000
- 过程或函数 'SelectByRow' 需要参数 '@text',但未提供该参数。
- 各位大大帮看看,我数据库服务器的配置项是否有异常
(SOURCE_RECORD_ID,LOCAL_ORG_ID,ACCESS_SYSTEM_ID,ORIGINAL_ID,
BIRTH_CARD_ID,CARD_TIME,CARD_ORG_CODE,CARD_ORG_NAME)
select
c.cb_id as SOURCE_RECORD_ID,
c.cb_fazhengunit as LOCAL_ORG_ID,
'HNBCS' as ACCESS_SYSTEM_ID,
c.cb_id as ORIGINAL_ID,
c.cb_birthno as BIRTH_CARD_ID,
(select top 1 convert(varchar(8),b.c_senddate,112) from csrk.dbo.tab_csz as b where c.cb_birthno=b.c_sendcard) as CARD_TIME,
c.cb_fazhengunit CARD_ORG_CODE,
c.cb_fazhengunitname CARD_ORG_NAME
from csrk.dbo.hospitaldata as h left join csrk.dbo.childbirthdata as c on h.hd_id = c.cb_id
where c.cb_birthno <> '' and h.hd_inputday between '20130101' and '20141231'
and hd_motheridno <> '' and hd_mothertype='身份证'