declare num integer; begin select count(distinct userid) into num from mmdb.user_info_t t where to_char(regdate,'yyyymm')='200802'; end;
那怎么调用这个变量呢。 declare num integer; begin select count(distinct userid) into num from mmdb.user_info_t t where to_char(regdate,'yyyymm')='200802'; end; 调用: select count(distinct userid)/num from mmdb.user_log_t
相当于下面的sql server语句功能 declare @num integer select @num=count(*) from t1 select c1/@num from t2
num integer;
begin
select count(distinct userid) into num from mmdb.user_info_t t where to_char(regdate,'yyyymm')='200802';
end;
declare
num integer;
begin
select count(distinct userid) into num from mmdb.user_info_t t where to_char(regdate,'yyyymm')='200802';
end;
调用:
select count(distinct userid)/num from mmdb.user_log_t
declare @num integer
select @num=count(*) from t1
select c1/@num from t2