oracle分组查询

【文件属性】：

文件名称：oracle分组查询

文件大小：1KB

文件格式：SQL

更新时间：2018-12-18 03:50:46

分组查询

oracle分组查询数据 select BFMBIGNAME,projectaddress,BFMSMALLNAME from(select BFMBIGNAME,projectaddress,BFMSMALLNAME,row_number() over (partition by BFMBIGNAME order by REGISTERDATE) id from Projectinfo) where id<=3;