mysql查询以获得正确的结果 [英] mysql query to get proper results

问题描述

大家好

我的桌子像:

hi all

my table like:

uid empid datetime
 1  9003  2012-09-26 09:20:00
 3  9000  2012-09-26 09:20:00
 4  9004  2012-09-26 09:20:00
 5  9002  2012-09-26 09:20:00 
 7  9001  2012-09-26 09:20:00
 18 9004  2012-09-25 09:15:00
 17 9000  2012-09-25 09:15:00
 11 9004  2012-09-26 08:59:00
 12 9002  2012-09-26 08:59:00
 15 9003  2012-09-25 09:15:00
 14 9001  2012-09-26 08:59:00
 19 9002  2012-09-25 09:15:00
 21 9001  2012-09-25 09:15:00

我写过类似
的查询

i have written query like

select * from attlog where TIME(datetime )>='09:00:00' and empid not in (select empid from attlog where TIME( datetime )<'09:00:00') AND DATE_FORMAT(DATE( datetime ) , '%m/%d/%Y' ) BETWEEN '09/25/2012' AND '09/26/2012' 

但是我需要获取日期时间来检查9点之后而不是9点之前的条目

现在显示为:

but i need to get datetime to check entries made after 9 but not before 9

now it is show like:

uid empid datetime
1  9003 2012-09-26 09:20:00
3  9000 2012-09-26 09:20:00
17 9000 2012-09-25 09:15:00
15 9003 2012-09-25 09:15:00

但它必须显示为

but it has to show like

uid empid datetime
1  9003 2012-09-26 09:20:00
3  9000 2012-09-26 09:20:00
18 9004 2012-09-25 09:15:00
17 9000 2012-09-25 09:15:00
15 9003 2012-09-25 09:15:00
19 9002 2012-09-25 09:15:00
21 9001 2012-09-25 09:15:00
22 9000 2012-09-25 09:15:00
23 9003 2012-09-25 09:15:00

没主意...请谁能帮我
在此先感谢

am out of ideas... please can any one help me
thanks in advance

推荐答案

"9点之后而不是9点之前"是互斥的，并且等于> 9:00"

因此您的查询工作正常.

"After 9 and not before 9" are mutually exclusive and is equal to ">9:00"

So your query is working correctly.

这篇关于mysql查询以获得正确的结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！