with tb1 
as
(select ROW_NUMBER() over(partition by hid order by lid) as row_num, *
from test3
where [max] >= 8 and [current] >= 8 and ([state] = 1 or [state] = 0))
select * into #t from tb1 where row_num = 1;

select SUM([state]) as [Count], COUNT(*) as Alls, STR(ROUND(SUM([state]) * 100 / COUNT(*), 0)) + '%' as 'P'
from #t;

------解决方案--------------------

SQL code
select 
sum(case when state=1 then 1 else 0 end) as [count] 
,count(1) as [count]
,P=Left(sum(case when state=1 then 1 else 0 end)*1.0 /count(1)*1.0*100,5) +'%'
from B a where max>=8 and [current]>=8 AND state>=0
AND not exists ( select 1 from B where a.hid=hid AND a.lid>lid)

------解决方案--------------------
探讨


引用:
SQL code
with tb1
as
(select ROW_NUMBER() over(partition by hid order by lid) as row_num, *
from test3
where [max] >= 8 and [current] >= 8 and ([state] = 1 or [state] = 0))
select……


------解决方案--------------------
探讨


引用:

引用:
SQL code
with tb1
as
(select ROW_NUMBER() over(partition by hid order by lid) as row_num, *
from test3
where [max] >= 8 and [current] >= 8 and ([state] = 1 or [stat……


------解决方案--------------------
 你创建个存储过程，然后再调用

------解决方案--------------------
1亿条数据，肯定是要超时的，你应该事先查好，创建个中间表什么的，然后从中间表里查才好，否则，只能是超时了。

------解决方案--------------------
直接查询1亿条？有索引吗？最好还是先分区，尽量减少单表数据量后再统计。