Question

sql语句中，select的条件group by having能和where做或运算么？

现在有这个的具体例子，数据库结构如下：
user_id user_scoor type time
1 20 1 1585222
我要在表中查找出，user_id的记录条数大于30条的或者是time小于3000的。这种group by having和where针对不同的列条件并且做或运算的select语句怎么写？

Answer 1

where条件：where user_Id > 30 or time < 3000
group by中having条件: group by field having (user_id>30 or time <3000)

group by having 例子(mysql中验证)
select * from sword_1_instrument
group by dateTime having( value > 1000 or dateTime < '2011-07-12 00:00:00')
order by value desc, dateTime

Answer 2

select *
from table1
group by user_id
having count(user_id) > 30
intersect
select *
from table1
where time < 3000

追问

intersect不是求交集么？我要的是并集。是或者，或者count(user_id) > 30
或者time < 3000 ，可以用那个？

追答

union