摘要：
/***人数统计Sql**/ /** 查询行政部***/ Declare @DepartID int;Declare @Alltotal int; Select @DepartID=Count(*) From Emp_Base where DepartID=2 select @Alltotal=Count(*) from emp_base SELECT SUM(@DepartID) AS DepartIDCount, SUM(@Alltotal) AS Alltotal, CAST(CONVERT (float, SUM(@DepartID)) * 100 / CONVERT (float, 阅读全文
