biany2的专栏

今天在力扣看到一道sql问题，链接https://leetcode-cn.com/problems/rank-scores/讲的是如何根据分数排名，官网显示中等难度。大概看了3种解决方法。方法1，参考oracle用窗口函数，本地调试，不支持方法2，用自关联查询的方式，官方显示是正确答案，本人亲测，在12w行数据里面跑，240秒没有跑完select a.Score as Sco...

数declare  @checkTime  datetime,        @intervarTime  int  set @checkTime = '2010-1-1 11:11:51' set  @intervarTime =5select  dateadd(ss, -(DATEPART(ss, @checkTime ) % 60), @checkTi

set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER procedure [dbo].[query_all_alarm_history]@userCode varchar(5),@startTime datetime,@endTime datetime,@alarmIds varchar(50)asSELECT UsersI

-------------获取时间段内表列 select name as tableName from [dbo].sysobjects where type='U' and (SUBSTRING(name,12,20) >= '20150622' and SUBSTRING(name,12,20) <= '20150626')

CALL SYSPROC.ADMIN_CMD('reorg table t1');