非常简单问题，重复的记录只显示一条！

[Any81]

sqll="select top 10 * from ad_info where hot='1' order by stime desc"

如果我想显示前10条记录，如果title字段重复，只显示一条！
但我要查询所有字段

谢谢，！

[angelheavens]

sqll="select distinct top 10 * from ad_info where hot='1' order by stime desc"

[Any81]

为什么回报错！

[srj911]

sqll="select distinct * from ad_info where hot='1' order by stime desc"

[LoneHome]

sqll="select distinct * from ad_info where hot='1' group by title order by stime desc"

[LoneHome]

sqll="select distinct top 10 title from ad_info where hot='1' group by title order by stime desc"

[Any81]

为什么就是报错

[Any81]

sqll="select top 10 * from ad_info where hot='1' order by stime desc"
set rsl=server.createobject("adodb.recordset")
rsl.open sqll,connstr,1,3

这样不报错，但是改一下sqll语句就报错了！
错的行是：rsl.open sqll,connstr,1,3

[pepos]

sqll="select distinct top 10 title from ad_info where hot='1' group by title order by stime desc"
set rsl=server.createobject("adodb.recordset")
rsl.open sqll,connstr,1,3
把这句rsl.open sqll,connstr,1,3后面的1,3改成3,3试试看，或者为rsl.open sqll,connstr,3也可以

[wggipkhgef]

rsl.open sqll,connstr,1,3
从你的多次回复中可以看出，这一行是决对没有错的了
错的还是SQL语句
sqll="select distinct top 10 * from ad_info where hot='1' order by stime desc"
应当没错的啊

[超级大笨狼]

<script language=vbs>
'功能：从很多字串中排除相同字串
'输入：很多字串组成的数组：
dim A,B
A=array("字串1","字串2","字串3","字串1","字串2","字串1","字串4")
'输出：
B=F(A)
'显示结果:B=array("字串1","字串2","字串3","字串4")
for each bbb in B
document.write bbb & "<br>"
next

'函数部分
function F(x)'这里x是形参
dim S,D
Set D = CreateObject("Scripting.Dictionary")
for each xxx in x
if not d.Exists(xxx) then D.Add xxx,xxx
next
for each key in D.Keys
S=S & key & " "
next
set D=nothing
F=split(trim(S))
end function
</script>

[yonghengdizhen]

select top 10 * from ad_info a where hot='1' and stime=(select max(stime) from ad_info where title=a.title) order by stime desc

[yonghengdizhen]

select top 10 * from ad_info a where hot='1' and stime=(select max(stime) from ad_info where hot='1' and title=a.title) order by stime desc

[xzq686]

select field1,field2 from table　where hot='1' group by field1,field2 having count(*)=1 order by stime desc'

[xzq686]

ad_infoid是表中的一个字段比如id
Select * From ad_info
Where (hot='1') and (ad_infoid in(Select distinct ad_infoid From ad_info))
Order by stime desc

[yonghengdizhen]

to xzq686(瞬)
你认为(ad_infoid in(Select distinct ad_infoid From ad_info))
这个条件和 1=1这个条件有差别吗?

[lovewing82]

是显示记录么？
记住 rsl.open sql,connstr,1,3后一定要确定数据库里有内容。。。没有内容的话会出错的
或者加上
if not rs.eof and not rs.bof then
......
else
......
end if

[tmdfsl]

select distinct top 10 title from tablename group by title

[qgandzly]

sqll="select distinct top 10 title from ad_info where hot='1' group by title order by stime desc"