数据库查询统计

最新推荐文章于 2024-03-20 18:26:31 发布

xxw_come

最新推荐文章于 2024-03-20 18:26:31 发布

阅读量826

点赞数

文章标签：数据库 user

本文链接：https://blog.csdn.net/xxw_come/article/details/1592049

版权

select global_user_id,
case
when A.global_user_pri='' or not A.global_user_pri in (select PositionName from global_Position) then (select max(OrderId) from global_Position)
when A.global_user_pri in (select PositionName from global_Position) then (select OrderId from global_Position

where PositionName=A.global_user_pri)
end as OrderId
from global_user A

create procedure [dbo].[sp_CategoryDocStatic]
@flag nvarchar(50) ='pub'
As
if(@flag='pub')
begin
  select global_doc_dir_name,SUM(CASE global_doc_private WHEN 'F' THEN 1 ELSE 0 END) as 'pubNum',SUM(CASE global_doc_private WHEN 'T' THEN 1 ELSE 0 END) as 'priNum',count(*) as TotalNum from dbo.view_doc group by global_doc_dir_name order by pubNum desc
end
else if(@flag='pri')
begin
  select global_doc_dir_name,SUM(CASE global_doc_private WHEN 'F' THEN 1 ELSE 0 END) as 'pubNum',SUM(CASE global_doc_private WHEN 'T' THEN 1 ELSE 0 END) as 'priNum',count(*) as TotalNum from dbo.view_doc group by global_doc_dir_name order by priNum desc
end
else if(@flag='total')
begin
  select global_doc_dir_name,SUM(CASE global_doc_private WHEN 'F' THEN 1 ELSE 0 END) as 'pubNum',SUM(CASE global_doc_private WHEN 'T' THEN 1 ELSE 0 END) as 'priNum',count(*) as TotalNum from dbo.view_doc group by global_doc_dir_name order by TotalNum desc
end