2021年1月28日
SQL Query aggregate may not appear in WHERE clause
摘要： SQL Query aggregate may not appear in WHERE clause 错误的写法 SELECT StartDate, ClientID, COUNT(1) AS Total FROM dbo.tbm_cti_CustomTableItem_BudgetPeriod W 阅读全文
posted @ 2021-01-28 10:17 ChuckLu 阅读(98) 评论(0) 推荐(0)
Is there any difference between GROUP BY and DISTINCT
摘要： Is there any difference between GROUP BY and DISTINCT 问题 I learned something simple about SQL the other day: SELECT c FROM myTbl GROUP BY C Has the sa 阅读全文
posted @ 2021-01-28 10:09 ChuckLu 阅读(86) 评论(0) 推荐(0)