代码如下:
select count (1) over (partition by comname) as store_count ,
* from tb_store where ComName='helloworld'
代码如下:
select count (1) over (partition by comname) as store_count ,
* from tb_store where ComName='helloworld'