时间:2021-07-01 10:21:17 帮助过:4人阅读
4.分区 partition
select tenantcode,row_number() over(partition by tenantcode order by tenantcode, brandcode, storecode ) groupid from tablename
若要分区筛选出id=1的,可以
select * from( select tenantcode,row_number() over(partition by tenantcode order by tenantcode, brandcode, storecode) groupid from tablename
) where groupid=1
Oracle 关键字、高级函数的使用
标签:alt distinct 高级 HERE rac oracl 使用 关键字 com