见如下表:
tbl_pro
pro_id pro_name pro_method pro_time
1 张三 水暖 2008-3-4
2 李四 安防 2008-4-6
。
。
。
。
求一查询,要实现
1。pro_time在2008-1-1日到2008-3-5之间
2。pro_name为张三或者pro_method为安防的纪录
tbl_pro
pro_id pro_name pro_method pro_time
1 张三 水暖 2008-3-4
2 李四 安防 2008-4-6
。
。
。
。
求一查询,要实现
1。pro_time在2008-1-1日到2008-3-5之间
2。pro_name为张三或者pro_method为安防的纪录
from tbl_pro
where pro_time between '2008-1-1' and '2008-3-5'
and (pro_name='张三' or pro_method='安防')
select * from tbl_pro
where (pro_time >= '2008-1-1' and pro_time <='2008-3-5')
and (pro_name='張三' or pro_method='安防')
select * from tbl_pro where pro_name ='张三' or pro_method ='安防'
from tbl_pro
where pro_time >= '2008-1-1' and pro_time <= '2008-3-5'
and (pro_name='张三' or pro_method='安防')這是似乎效率會更高
where pro_time between '2008-1-1' and '2008-3-5'
and (pro_name='张三' or pro_method='安防')
from tbl_pro
where pro_time between '2008-1-1' and '2008-3-5'
and (pro_name='张三' or pro_method='安防')
select * from tbl_pro
where pro_time between '2008-1-1' and '2008-3-5' and (pro_name='張三' or pro_method='安防')
from tbl_pro
where pro_time between '2008-1-1' and '2008-3-5'
and (pro_name='张三' or pro_method='安防')
select * from tbl_pro where pro_time between '2008-1-1 00:00:00' and '2008-3-5 12:59:59' and (pro_name='张三' or pro_method='安防')