Question

ACCESS重复记录,怎么只显示1条

表CHECKINOUT
userid CHECKTIME
1 abcd
1 abcd
1 abce
1 abce
1 abcf
1 abcf
1 abcg
1 abch
1 abci
1 abcj
需要查询结果
userid CHECKTIME
1 abcd
1 abce
1 abcf
1 abcg
1 abch
1 abci
1 abcj
select count(distinct CHECKTIME) from CHECKINOUT
此语句不能使用.提示操作符丢失

Answer 1

1.
<!--#include file="数据库连接页面.asp"-->
<%
set rs=server.createobject("ADODB.Recordset")
sql="select count(distinct CHECKTIME) from CHECKINOUT where 条件写上"
rs.open sql,conn,1,1
%>

2.是否写循环语句了
<%do while not rs.eof%>
<%=rs("CHECKTIME")%>
<%
rs.movenext
if rs.eof then exit do
loop
%>