【文件属性】:
文件名称: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;