select Number ,warnTime ,Model From warningrecord Where [Date]>='2012-12-05' and [Date]<='2012-12-05' and( WarnType='aa') and (Number in(select Number From warningrecord Where [Date]>='2012-12-05' and [Date]<='2012-12-05' and WarnType='aa' group by Number HAVING count(Number)>4) 以上查询语句,运行报错: 消息 102,级别 15,状态 1,第 5 行 ')' 附近有语法错误。 也就是最后一行报错
SELECT * FROM 表名 WHERE 设备编号 IN (SELECT 设备编号 FROM 表名 GROUP BY 设备编号 HAVING COUNT(设备编号)>=2)
SELECT * FROM 表名 WHERE 设备编号 IN (SELECT 设备编号 FROM 表名 GROUP BY 设备编号 HAVING COUNT(设备编号)>=2)group by 和having是必须的
Where [Date]>='2012-12-05' and [Date]<='2012-12-05' and( WarnType='aa')
and (Number in(select Number From warningrecord
Where [Date]>='2012-12-05' and [Date]<='2012-12-05' and WarnType='aa'
group by Number HAVING count(Number)>4)
以上查询语句,运行报错:
消息 102,级别 15,状态 1,第 5 行
')' 附近有语法错误。
也就是最后一行报错
WHERE 设备编号 IN (SELECT 设备编号 FROM 表名 GROUP BY 设备编号 HAVING COUNT(设备编号)>=2)
WHERE 设备编号 IN (SELECT 设备编号 FROM 表名 GROUP BY 设备编号 HAVING COUNT(设备编号)>=2)group by 和having是必须的