我在我的表格上有这些字段
month
year
我想基于这个进行查询
month BETWEEN 4 AND 12 AND year = 2008
或者
month BETWEEN 1 AND 10 AND year is greater than 2008 but equal or less than 2009
我尝试了这个,但是没有得到正确的查询结果。
"WHERE month BETWEEN 4 AND 12 AND year = 2008 OR month BETWEEN 1 AND 10 AND year 2008<=2009";
注意:这里的数字是可变的,我为了让您更容易理解展示了实际数字 :) 有需要帮助吗?
year = (2008<=2009) 表示年份必须大于2008,但小于等于2009。
year = (2008<=2009)
的意思是什么? - xdazzyear = (2008<=2009)
的想法是什么?你想表达什么条件? - Havelockyear = (2008<=2009)
дјҡеҫ—еҲ°year = (1)
пјҢеӣ жӯӨз»“жһңдёәFALSEгҖӮеҪ“еңЁиҜҘиҜӯеҸҘе‘ЁеӣҙжІЎжңүдҪҝз”Ё()
ж—¶пјҢдҪҝз”ЁOR
ж—¶иҰҒе°ҸеҝғгҖӮеңЁдёҠиҝ°жғ…еҶөдёӯпјҢеҰӮжһңд»…month BETWEEN 1 AND 10
дёәTRUEпјҢеҲҷе®ғеҸҜд»Ҙиҝ”еӣһдёҖиЎҢгҖӮ - Robin Castlin2008 < x <= 2009
并且 x 是整数 =>x == 2009
- Nir Alfasi