我有一个简单的查询,它可以完美地工作:
(select distinct ACTIVE_MEMBERS, BRANCH_MEMBERS from
( select count(*) from pink_floyd pf ) as ACTIVE_MEMBERS,
( select count(*) from pink_floyd pf ) as BRANCH_MEMBERS
);
根据上面的查询,我想创建视图--我是这样做的:
create or replace view v_monthly_data AS
select data.active_members, data.branch_members
from (select distinct ACTIVE_MEMBERS, BRANCH_MEMBERS from
( select count(*) from pink_floyd pf ) as ACTIVE_MEMBERS,
( select count(*) from pink_floyd pf ) as BRANCH_MEMBERS
) as data;
但这似乎是不正确的.我将不胜感激地解释我创建这个视图的正确方式. 此外,我不希望创建多个视图,然后加入它们.