22,209
社区成员
发帖
与我相关
我的任务
分享
select *
from blog_Dn1 t1
inner join blog_Dn1 t2
on t1.domain = t2.domain
where t1.id between 1 and 1000000 and
t2.id between 1000001 and 2000000 and
t2.num +100000 = t1.num
DECLARE @Day1 INT
DECLARE @Day2 INT
DECLARE @DayNums INT
SET @DayNums = 1000000
SET @Day1 = 1
SET @Day2 = 2
SELECT
b.domain,a.num AS [上次名次],b.num AS [今天名次],(a.num - b.num) AS [提升名次]
FROM
blog_Dn1 a INNER JOIN blog_Dn1 b ON b.domain = a.domain
WHERE
a.id BETWEEN @DayNums*(@Day1-1) + 1 AND @DayNums*@Day1 AND
b.id BETWEEN @DayNums*(@Day2-1) + 1 AND @DayNums*@Day2 AND
(a.num - b.num) > 100000