07 2017 档案

[SQL] 查询指定Account的数据记录数不超过20条
摘要：having 后面只能用 COUNT(*)，不能用 cnt 阅读全文
posted @ 2017-07-25 10:31 Sunshine168 阅读(376) 评论(0) 推荐(0)
[SQL] 查询不重复ID的最新的一天的数据
摘要：select top 100 * from ClientSecurityReturnIndex where EffectiveDate=(select MAX(EffectiveDate) from ClientSecurityReturnIndex as tb where ClientSecurityId=ClientSecurityReturnIndex.ClientSecurityId) ... 阅读全文
posted @ 2017-07-18 17:22 Sunshine168 阅读(2289) 评论(0) 推荐(0)
[SQL] 查询指定某个条件的记录数
摘要：select AccountId,COUNT(*) as cnt from AccountReturnIndex group by AccountId having COUNT(*)<20 阅读全文
posted @ 2017-07-13 09:41 Sunshine168 阅读(1334) 评论(0) 推荐(0)
[SQL] 查询出不在特定批量记录中的数据
摘要：create table #Account(AccountId int) insert into #Account select 1500722090 union select 1500722091 union select 1500722092 union select 1500722316 union select 1500722317--'union' is auto filter du... 阅读全文
posted @ 2017-07-06 10:28 Sunshine168 阅读(357) 评论(0) 推荐(0)