select * from
(select count(id) as good from table where id between '1' and '10' ) a,
(select count(id) as good from table where id between '1' and '11') b
结果是 一条记录里，两个字段
good good
10 11
请问要怎样把结果变成 两条记录，同一字段呢
good
10
11
------解决方案--------------------
select count(id) as good from table where id between '1' and '10'
union all
select count(id) as good from table where id between '1' and '11'
------解决方案--------------------
- SQL code
select count(id) as good from table where id between '1' and '10'union allselect count(id) as good from table where id between '1' and '11'