sql Ôõôд???

TB1
SQL code:

ID DATE
1 2009Äê1ÔÂ
2 2009Äê12ÔÂ
3 2009Äê3ÔÂ
4 2009Äê6ÔÂ
5 2009Äê2ÔÂ
6 2009Äê3ÔÂ
7 2009Äê6ÔÂ



²éѯid ÔÚ 3,4,5,6,7 ·¶Î§ÄÚ ËùÓÐ date µÃµ½:2009Äê3ÔÂ,2009Äê6ÔÂ,2009Äê2ÔÂ

---

SQL code:
select distinct date from tb1 where id in (3,4,5,6,7)

---

SQL code:
select date from between id 3 and 7

---

SQL code:
select distinct date from tb1 where id in (3,4,5,6,7) order by date
select distinct date from tb1 where id between 3 and 7 order by date

---

select distinct Date from TB1 where id in(3,4,5,6,7)

---

²»ÊÇ
Ö´Ðнá¹û ÔÚÒ»¸öµ¥Ôª¸ñÄÚ

SQL code:

½á¹û
date
--------------------------------
2009Äê3ÔÂ,2009Äê6ÔÂ,2009Äê2ÔÂ

---

½á¹ûÔÚÒ»¸öµ¥Ôª¸ñÄÚ,×îºÃÈÕÆÚÅÅÐò,ÈçÏÂ
SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/