Select Count(DATA_COMPLETE.SN), DATA_COMPLETE.STATION_CODE From DATA_COMPLETE Where DATA_COMPLETE.WORK_DATE = (Select trunc(SYSDATE) From dual) Group By DATA_COMPLETE.STATION_CODE; Select Count(DATA_COMPLETE.SN), DATA_COMPLETE.STATION_CODE From DATA_COMPLETE Where DATA_COMPLETE.WORK_DATE = (Select trunc(SYSDATE-1) From dual) Group By DATA_COMPLETE.STATION_CODE; 这两条查询结果怎么合并到一起
通过union来连接 Select Count(DATA_COMPLETE.SN), DATA_COMPLETE.STATION_CODE From DATA_COMPLETE Where DATA_COMPLETE.WORK_DATE = (Select trunc(SYSDATE) From dual) Group By DATA_COMPLETE.STATION_CODE union Select Count(DATA_COMPLETE.SN), DATA_COMPLETE.STATION_CODE From DATA_COMPLETE Where DATA_COMPLETE.WORK_DATE = (Select trunc(SYSDATE-1) From dual) Group By DATA_COMPLETE.STATION_CODE;
你可以 用 后台生成table~ 按照你需要的 就成··
谢谢大家,已解决~ 数据库中建立如下视图,然后用VS自带报表实现 create or replace view report_fox as select "COUNT(DATA_COMPLETE.SN)" as cnum,"WDATE" as wdate,"STATION_NAME","ORD" as ord from (Select Count(DATA_COMPLETE.SN), ('A今天') wdate, CODE_STATION.STATION_NAME,CODE_STATION.Ord From DATA_COMPLETE Inner Join CODE_STATION On CODE_STATION.STATION_CODE = DATA_COMPLETE.STATION_CODE Where DATA_COMPLETE.WORK_DATE = trunc(SYSDATE) Group By CODE_STATION.STATION_NAME,CODE_STATION.Ord Union Select Count(DATA_COMPLETE.SN), ('B昨天') wdate, CODE_STATION.STATION_NAME,CODE_STATION.Ord From DATA_COMPLETE Inner Join CODE_STATION On CODE_STATION.STATION_CODE = DATA_COMPLETE.STATION_CODE Where DATA_COMPLETE.WORK_DATE = trunc(SYSDATE-1) Group By CODE_STATION.STATION_NAME,CODE_STATION.Ord Union Select Count(DATA_COMPLETE.SN), ('C本月') wdate, CODE_STATION.STATION_NAME,CODE_STATION.Ord From DATA_COMPLETE Inner Join CODE_STATION On CODE_STATION.STATION_CODE = DATA_COMPLETE.STATION_CODE Where trunc(DATA_COMPLETE.WORK_DATE,'mm') = trunc(sysdate,'mm') Group By CODE_STATION.STATION_NAME,CODE_STATION.Ord Union Select Count(DATA_COMPLETE.SN), ('D本年') wdate, CODE_STATION.STATION_NAME,CODE_STATION.Ord From DATA_COMPLETE Inner Join CODE_STATION On CODE_STATION.STATION_CODE = DATA_COMPLETE.STATION_CODE Where trunc(DATA_COMPLETE.WORK_DATE,'YYYY') = trunc(sysdate,'YYYY') Group By CODE_STATION.STATION_NAME,CODE_STATION.Ord) order by ord,wdate;
From DATA_COMPLETE
Where DATA_COMPLETE.WORK_DATE = (Select trunc(SYSDATE) From dual)
Group By DATA_COMPLETE.STATION_CODE;
Select Count(DATA_COMPLETE.SN), DATA_COMPLETE.STATION_CODE
From DATA_COMPLETE
Where DATA_COMPLETE.WORK_DATE = (Select trunc(SYSDATE-1) From dual)
Group By DATA_COMPLETE.STATION_CODE;
这两条查询结果怎么合并到一起
From DATA_COMPLETE
Where DATA_COMPLETE.WORK_DATE = (Select trunc(SYSDATE) From dual)
Group By DATA_COMPLETE.STATION_CODE
union
Select Count(DATA_COMPLETE.SN), DATA_COMPLETE.STATION_CODE
From DATA_COMPLETE
Where DATA_COMPLETE.WORK_DATE = (Select trunc(SYSDATE-1) From dual)
Group By DATA_COMPLETE.STATION_CODE;
数据库中建立如下视图,然后用VS自带报表实现
create or replace view report_fox as
select "COUNT(DATA_COMPLETE.SN)" as cnum,"WDATE" as wdate,"STATION_NAME","ORD" as ord
from
(Select Count(DATA_COMPLETE.SN), ('A今天') wdate, CODE_STATION.STATION_NAME,CODE_STATION.Ord
From DATA_COMPLETE
Inner Join CODE_STATION
On CODE_STATION.STATION_CODE = DATA_COMPLETE.STATION_CODE
Where DATA_COMPLETE.WORK_DATE = trunc(SYSDATE)
Group By CODE_STATION.STATION_NAME,CODE_STATION.Ord
Union
Select Count(DATA_COMPLETE.SN), ('B昨天') wdate, CODE_STATION.STATION_NAME,CODE_STATION.Ord
From DATA_COMPLETE
Inner Join CODE_STATION
On CODE_STATION.STATION_CODE = DATA_COMPLETE.STATION_CODE
Where DATA_COMPLETE.WORK_DATE = trunc(SYSDATE-1)
Group By CODE_STATION.STATION_NAME,CODE_STATION.Ord
Union
Select Count(DATA_COMPLETE.SN), ('C本月') wdate, CODE_STATION.STATION_NAME,CODE_STATION.Ord
From DATA_COMPLETE
Inner Join CODE_STATION
On CODE_STATION.STATION_CODE = DATA_COMPLETE.STATION_CODE
Where trunc(DATA_COMPLETE.WORK_DATE,'mm') = trunc(sysdate,'mm')
Group By CODE_STATION.STATION_NAME,CODE_STATION.Ord
Union
Select Count(DATA_COMPLETE.SN), ('D本年') wdate, CODE_STATION.STATION_NAME,CODE_STATION.Ord
From DATA_COMPLETE
Inner Join CODE_STATION
On CODE_STATION.STATION_CODE = DATA_COMPLETE.STATION_CODE
Where trunc(DATA_COMPLETE.WORK_DATE,'YYYY') = trunc(sysdate,'YYYY')
Group By CODE_STATION.STATION_NAME,CODE_STATION.Ord)
order by ord,wdate;