Çë½ÌÒ»¸ösqlÓï¾äд·¨£¿

[b][/b]ÓÐ1¸ö±ít£¬Äê¶ÈºÍÆڼ䶼ÊÇintÀàÐÍ£¬Çó´óÓÚ £¨Äêµ×=2007 ÆÚ¼ä=1£©²¢ÇÒСÓÚ£¨Äê¶È=2008 ÆÚ¼ä=3£©Ö®¼äµÄ¼Ç¼
Õâ¸öSQLÓï¾äµÃÔõôд£¿

Àý±ít:

Äê¶È ÆÚ¼ä ½ð¶î
2007 1 10
2007 2 15
2007 3 20
2008 1 10
2008 2 30
2008 3 35

---

SQL code:
select * from t
where (Äê¶È between 2007 and 2008 )
(and ÆÚ¼ä between 1 and 3)

---

select *
from t
where ltrim(Äê¶È)+ltrim(ÆÚ¼ä) between '20071' and '20083'

---

where Äê¶È between 2007 and 2008 and ÆÚ¼ä between 1 and 3

---

ÒýÓÃ

SQL codeselect*from twhere (Äê¶Èbetween2007and2008 )
(and ÆÚ¼äbetween1and3)

SQL code:
--¸üÕý語·¨錯誤
--結¹ûÊÇʲ麼
select * from t
where (Äê¶È between 2007 and 2008 )
and (ÆÚ¼ä between 1 and 3)

---

ÒýÓÃ

SQL codeselect*from twhere (Äê¶Èbetween2007and2008 )
(and ÆÚ¼äbetween1and3)

ÕâÑùд²»¶Ô£¬Äê¶Èbetween2007and2008£¬Èç¹ûÒª²éµÄ¶¼ÊÇ2007ÄêÄØ£¿±ÈÈçÒªÊÇÖ»²é2007ÄêÆÚ¼ä1µ½ÆÚ¼ä3µÄÊý

---

select *
from t
where ltrim(Äê¶È)+to_char(ltrim(ÆÚ¼ä),'mm') between '200701' and '200803'

---

ÒýÓÃ

select *
from t
where ltri