除了用这种
with Incubator_table
as (select row_number() over (order by count(BusinessIncubationId) desc) as rowIndex, UnitName, EnterpriceCode, count(BusinessIncubationId) as CorporationCount from IncubatorRegister as (select row
with Incubator_table
as (select row_number() over (order by count(BusinessIncubationId) desc) as rowIndex, UnitName, EnterpriceCode, count(BusinessIncubationId) as CorporationCount from IncubatorRegister as (select row