查询每个班的第二名(考虑并列)
数据源
createtables1(
idint,
namevarchar(10),
scoreint,
classnoint)
insertintos1values
(1,xxj,100,1),
(2,xxj2,100,1),
(3,xxj3,99,1,),
(4,xxj4,99,1),
(5,xf,99,2),
(6,xf2,98,2),
(7,xf3,98,2),
(8,xz,100,3),
(9,xz2,98,3)
方法一:使用dense_rank()ov