select '',no,name from 表名 union all select 'total',sum(no),'' from 表名
SQL中可以,不知Oracle中行不行: select no,name from tablename union all select sum(no),'' from tablename
create table tablename (no int,name varchar(20)) insert into ... select no,name from tablename union select sum(no),'' from tablename 1 apple 2 banana 3 pear 6
select null 描述,no,name from tablename union all select 'total',sum(no),null from tablename
select '',* from tablename union all select 'totale',sum(no),'' from tablename
create table ai (no int, name varchar(100)) insert into ai select '1', 'apple' insert into ai select '2' , 'banana' insert into ai select '3' , 'pear'select '',* from ai union all select 'total',count(*),'' from ai
union all
select 'total',sum(no),'' from 表名
select no,name from tablename
union all
select sum(no),'' from tablename
insert into ...
select no,name from tablename union select sum(no),'' from tablename
1 apple
2 banana
3 pear
6
union all
select 'total',sum(no),null from tablename
实际上oracle还有更灵活的over ()语法以非子查询方式实现分类小计..在某些方面oracle的语法还是比sql server要灵活,虽然他们的界面做得有够变态
union all
select 'totale',sum(no),'' from tablename
insert into ai select '1', 'apple'
insert into ai select '2' , 'banana'
insert into ai select '3' , 'pear'select '',* from ai
union all
select 'total',count(*),'' from ai