34,838
社区成员




create table A(id int, name varchar(10) , buy int, time datetime)
insert into A values(1 , 'x1' , 10 , '2008-01-01')
insert into A values(2 , 'x2' , 20 , '2008-01-02')
insert into A values(3 , 'x3' , 10 , '2008-01-03')
insert into A values(4 , 'x4' , 10 , '2008-01-04')
insert into A values(5 , 'x5' , 10 , '2008-01-05')
insert into A values(6 , 'x4' , 10 , '2008-01-05')
insert into A values(7 , 'x1' , 10 , '2008-01-06')
go
select name
from
(select name ,sum(buy) as buy
from a
where time between '2008-01-01 ' and '2008-01-06'
group by name) a
where buy < 20
drop table a
/*
name
----------
x3
x5
(所影响的行数为 2 行)
*/
create table A(id int, name varchar(10) , buy int, time datetime)
insert into A values(1 , 'x1' , 10 , '2008-01-01')
insert into A values(2 , 'x2' , 20 , '2008-01-02')
insert into A values(3 , 'x3' , 10 , '2008-01-03')
insert into A values(4 , 'x4' , 10 , '2008-01-04')
insert into A values(5 , 'x5' , 10 , '2008-01-05')
insert into A values(6 , 'x4' , 10 , '2008-01-05')
insert into A values(7 , 'x1' , 10 , '2008-01-06')
go
select name from A where time between '2008-01-01' and '2008-01-06' group by name having sum(buy) < 20
drop table A
/*
name
----------
x3
x5
(所影响的行数为 2 行)
*/
select name
from
(select name ,sum(buy) as buy
from ta
where time between '2008-01-01 ' and '2008-01-06'
group by name) a
where buy < 20