SQL code:
if object_id('tb') is not null
drop table tb
create table tb(type varchar(20),accessoryNo varchar(20),deviceNo varchar(10),lastTime decimal(27,6))
insert tb
select 'A','s10','z11',10 union all
select 'B','s10','z11',11 union all
select 'A','s11','z12',51 union all
select 'A','s10','z11',91 union all
select 'A','s10','z13',29 union all
select 'B','s10','z11',30 union all
select 'B','s10','z11',50 union all
select 'B','s10','z11',85 union all
select 'A','s10','z11',60 union all
select 'A','s10','z11',30 union all
select 'B','s10','z11',33
--要求的查询结果
/*
型别 合计 10以下 10-30 31-60 61-90 90以上
A 6 0 3 2 0 1
B 5 0 2 2 1 0
合计 11 0 5 4 1 1
*/
drop table tb
--查询语句应该怎么写呢？
SQL code:
with t as(
select [type] as 型别,
count(*) as 合计,
(select count(*) from tb as tt1 where lastTime<10 and tt1.[type] = t1.[type]) as [10以下],
(select count(*) from tb as tt2 where lastTime between 10 and 30 and tt2.[type] = t1.[type]) as [10至30],
(select count(*) from tb as tt3 whe
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
上面一个简单的SQL,执行时间2.6� ......
