1.SELECT * FROM [Logging].[dbo].[ExceptionLog]
WHERE (LogId IN(SELECT MIN(LogId) AS Expr1 FROM [Logging].[dbo].[ExceptionLog]
AS ExceptionLog_1 GROUP BY StackTrace ) )
2. SELECT * FROM [Logging].[dbo].[ExceptionLog] WHERE
(LogId IN(SELECT MIN(LogId) AS Expr1 FROM [Logging].[dbo].[ExceptionLog]
AS ExceptionLog_1 where( (CreateDate<'2012-05-17' ) or
(CreateDate='2012-05-17' and CreateTime<='15:02:21.9070000'))
GROUP BY StackTrace))
3. SELECT * FROM [Logging].[dbo].[ExceptionLog] WHERE
(LogId IN(SELECT MIN(LogId) AS Expr1 FROM [Logging].[dbo].[ExceptionLog]
AS ExceptionLog_1 where ((CreateDate>'2012-05-17' )
or (CreateDate='2012-05-17' and CreateTime>'15:02:21.9070000'))
GROUP BY StackTrace)) 为啥1的执行结果不等于2、3两条执行结果的总和呢?
WHERE (LogId IN(SELECT MIN(LogId) AS Expr1 FROM [Logging].[dbo].[ExceptionLog]
AS ExceptionLog_1 GROUP BY StackTrace ) )
2. SELECT * FROM [Logging].[dbo].[ExceptionLog] WHERE
(LogId IN(SELECT MIN(LogId) AS Expr1 FROM [Logging].[dbo].[ExceptionLog]
AS ExceptionLog_1 where( (CreateDate<'2012-05-17' ) or
(CreateDate='2012-05-17' and CreateTime<='15:02:21.9070000'))
GROUP BY StackTrace))
3. SELECT * FROM [Logging].[dbo].[ExceptionLog] WHERE
(LogId IN(SELECT MIN(LogId) AS Expr1 FROM [Logging].[dbo].[ExceptionLog]
AS ExceptionLog_1 where ((CreateDate>'2012-05-17' )
or (CreateDate='2012-05-17' and CreateTime>'15:02:21.9070000'))
GROUP BY StackTrace)) 为啥1的执行结果不等于2、3两条执行结果的总和呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货