连续最大:
SELECT M.* FROM #temp M
INNER JOIN (
SELECT ISNULL(A.score,0)-b.score AS score,B.id FROM
#temp AS B
LEFT JOIN #temp A ON A.id=B.id+1 ) N ON M.id=N.id
WHERE n.score<0
如果ID不连续,用rownum代替
连续最大:
SELECT M.* FROM #temp M
INNER JOIN (
SELECT ISNULL(A.score,0)-b.score AS score,B.id FROM
#temp AS B
LEFT JOIN #temp A ON A.id=B.id+1 ) N ON M.id=N.id
WHERE n.score<0
如果ID不连续,用rownum代替
转载于:https://www.cnblogs.com/kafeibuhuizui/p/11142490.html