select count(1) from biao where id=12345
追问这样不行哦 如过我只查询2列的话就不行
select top 1 I1,sum(RunTime) as RunTime from PDS_RunDaily where I1 = '104' and MillID=10 and InsertTime
between '2013-11-23' and '2013-11-24' group by I1
我这sql 语句是这样的
追答需要判断 检测!
if exists (select top 1 I1,sum(RunTime) as RunTime from PDS_RunDaily where I1 = '104' and MillID=10 and InsertTime
between '2013-11-23' and '2013-11-24' )
begin
select top 1 I1,sum(RunTime) as RunTime from PDS_RunDaily where I1 = '104' and MillID=10 and InsertTime
between '2013-11-23' and '2013-11-24' group by I1
end
else
begin
select I1 = 0,RunTime = 0
end
追问大神
本回答被提问者和网友采纳