在某一段时间内 如果这个人登录的次数 超过2次就显示这个人 这段时间内 所有的登录明细--------------------------------------- SELECT * FROM t1where Ain ( select A from t1 group by A havint count(A)=2)order by A-----------------------怎么加上某一时间段
t1表 ----------------------------------- A B C (时间) 1 2 时间1 1 3 时间2 1 4 时间3 2 1 时间4 2 2 时间5--------------------------- 比如这在时间1---时间3之间 有三次SELECT A ,B,C FROM t1 WHERE A IN ( SELECT A FROM t1 group by A ,c HAVING c>=时间1 AND c<=时间3 AND COUNT(A)=2 )ORDER BY A--------------------但不对。。-------------------结果应该:A B C (时间) 2 1 时间4 2 2 时间5
SELECT A ,B,C FROM t1 WHERE (A IN ( SELECT A FROM t1 group by A ,c COUNT(A)>=2 ))AND ( c>=时间1 AND c<=时间3 )
t1表
-----------------------------------
A B C (时间)
1 2 时间1
1 3 时间2
1 4 时间3
2 1 时间4
2 2 时间5---------------------------
比如这在时间1---时间3之间 有三次SELECT A ,B,C FROM t1
WHERE A IN
( SELECT A FROM t1 group by A ,c HAVING c>=时间1 AND c<=时间3 AND
COUNT(A)=2
)ORDER BY A--------------------但不对。。-------------------结果应该:A B C (时间)
2 1 时间4
2 2 时间5
WHERE (A IN
( SELECT A FROM t1 group by A ,c
COUNT(A)>=2
))AND ( c>=时间1 AND c<=时间3 )