开窗函数:今天学习了,这个很重要,不知道以前需要很麻烦才能实现的功能,在开窗函数里面一下子就实现了。具体语法是:
select *, row_number() over (partition by a.system_id order by a.name) as RowNum from tableA a
看结果就知道了。
select *, row_number() over (partition by a.system_id order by a.name) as RowNum from tableA a
看结果就知道了。