- 博客(4)
- 收藏
- 关注
转载 [SQL] 查询指定Account的数据记录数不超过20条
select AccountId,COUNT(*) as cnt from tablename group by AccountIdhaving COUNT(*)<20having 后面只能用 COUNT(*),不能用 cnt转载于:https://www.cnblogs.com/wynlfd/p/7232671.html...
2017-07-25 10:31:00 377
转载 [SQL] 查询不重复ID的最新的一天的数据
select top 100 * from ClientSecurityReturnIndexwhere EffectiveDate=(select MAX(EffectiveDate) from ClientSecurityReturnIndex as tb where ClientSecurityId=ClientSecurityReturnIndex.ClientSecur...
2017-07-18 17:22:00 289
转载 [SQL] 查询指定某个条件的记录数
select AccountId,COUNT(*) as cnt from AccountReturnIndex group by AccountIdhaving COUNT(*)<20转载于:https://www.cnblogs.com/wynlfd/p/7158858.html
2017-07-13 09:41:00 988
转载 [SQL] 查询出不在特定批量记录中的数据
create table #Account(AccountId int)insert into #Accountselect 1500722090union select 1500722091union select 1500722092union select 1500722316union select 1500722317--'union' is a...
2017-07-06 10:28:00 150
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人