SQL如何求解连续年份的问题？
作者:IT科技 来源:IT科技 浏览: 【大中小】 发布时间:2025-11-05 02:30:33 评论数:
复制CREATETABLE #t(TEAM varchar(20),求解 Y int) INSERT #t(TEAM,Y) VALUES (活塞,1990), (公牛,1991), (公牛,1992), (公牛,1993), (火箭,1994), (火箭,1995), (公牛,1996), (公牛,1997), (公牛,1998), (马刺,1999), (湖人,2000), (湖人,2001), (湖人,2002), (马刺,2003), (活塞,2004), (马刺,2005), (热火,2006), (马刺,2007), (凯尔特人,2008), (湖人,2009), (湖人,2010); SELECT RN=IDENTITY(INT),* INTO #a FROM #t ORDERBY TEAM,Y SELECT a.TEAM, MIN(a.Y) B, MAX(a.Y) E FROM #a a WHERE EXISTS( SELECT 1 FROM #a WHERE TEAM=a.TEAM AND (Y=a.Y-1 OR a.Y=Y-1) ) GROUPBY a.TEAM,Y-RN DROPTABLE #t,#a 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.