帮忙看一下，sql语句怎样写

[snower01]

数据库access,结构如下(表名:article)
id content sdate
1 aaa 2007-3-1
2 bbb 2007-2-28
3 ccc 2007-3-1
4 ddd 2007-2-28


<select name="rq" size="1" >
<%
set rs1=server.createobject("adodb.recordset")
rs1.Open "select * from article order by id desc",conn,1,1

do while not rs1.eof
dtdate=rs1("sdate")
%>
<option value="<%=dtdate%>"><%=dtdate%></option> option中怎样实现2007-2-28、2007-3-1各只有一条
<%
rs1.movenext
loop
%>
</select>

[snower01]

已解决
select Distinct sdate from [article] order by sdate desc

[OracleRoob]

select sdate from article group by sdate order by Min(id) desc

[OracleRoob]

自己解决更好！

[wwwwb]

自己解决更好！

[liuyann]

select sdate from article group by sdate order by Min(id) desc

[OracleRoob]

select sdate from article group by sdate order by Min(id) desc