多少数据这样能显示出来select a.plan_id as id from plan2 a inner join product b on a.order_no=b.order_no
group by a.plan_id,a.order_no,a.product_no,b.order_no,b.product_no现在怎么计算它有多少条呢?是:select count(*) as spn from plan2 a inner join product b on a.order_no=b.order_no
group by a.plan_id,a.order_no,a.product_no,b.order_no,b.product_no这个好像不对select a.plan_id,count(*) from plan2 a inner join product b on a.order_no=b.order_no
group by a.plan_id
这个得到的结果是:
total
1
1
2
1
而不是正确答案:4
group by a.plan_id,a.order_no,a.product_no,b.order_no,b.product_no现在怎么计算它有多少条呢?是:select count(*) as spn from plan2 a inner join product b on a.order_no=b.order_no
group by a.plan_id,a.order_no,a.product_no,b.order_no,b.product_no这个好像不对select a.plan_id,count(*) from plan2 a inner join product b on a.order_no=b.order_no
group by a.plan_id
这个得到的结果是:
total
1
1
2
1
而不是正确答案:4
select......
set @rows = @@rowcount
select count(*) from plan2 a inner join product b on a.order_no=b.order_no