asp中这个SQL语句为什么老报错？

sql="select * from A where riqi between '"&a1&"' and '"&a2&"'group by riqi ORDER BY riqi desc"


表A中，在时间段a1和a2间，查找记录，然后排序。
数据表中同一日期有多条记录，现在想让查询结果中同一日期的多条记录只显示出一条，所以用group by，但总是不对，
请教大家。

---

问一下怎么上传东西啊，忘了

---

sql="select riqi from A where riqi between '"&a1&"' and '"&a2&"' group by riqi ORDER BY riqi desc"

---

sql="select discint * from A where riqi between '"&a1&"' and '"&a2&"' group by riqi ORDER BY riqi desc"

---

初来论坛学习了

---

sql="select top 1 * from A where riqi between '"&a1&"' and '"&a2&"'group by riqi ORDER BY riqi desc"

加上top 1

---

sql="select distinct riqi from A where riqi between '"&a1&"' and '"&a2&"' ORDER BY riqi desc"

请注意检查riqi的字段类型是否正确！

---

并且可以在distinct riqi 后面加上你要的字段，用逗号隔开即可！

---

引用

sql="select top 1 * from A where riqi between '"&a1&"' and '"&a2&"'group by riqi ORDER BY riqi desc"

加上top 1