SQL查询重复数据问题

[dys_198102]

Set RsNews = Server.CreateObject("ADODB.Recordset")
sql="select top 10 * from Hover_Product where BigClassName='"&trim(request("BigClassName"))&"'or (Title LIKE'%"&trim(request("Title"))&"%') or Spec='"&trim(request("Spec"))&"' or Title='"&trim(request("pinming"))&"' order by ArticleID desc"
RsNews.open sql,conn,1,1
如果Title有重复数据，只显示一次。。。。。。
这个应怎么用SQL来写。。。。。。？

[sd5816690]

select distinct * from table

[一把编程的菜刀]

使用gropu by Title

[一把编程的菜刀]

或者使用
distinct(Title)

[jhwcd]

sql="select top 10 * from Hover_Product where  (BigClassName='"&trim(request("BigClassName"))&"'or (Title LIKE'%"&trim(request("Title"))&"%') or Spec='"&trim(request("Spec"))&"' or Title='"&trim(request("pinming"))&"')  and id  in (select max(id) from Hover_Product group by Title) order by ArticleID desc" 

[jhwcd]

sql="select top 10 * from Hover_Product where  (BigClassName='"&trim(request("BigClassName"))&"' or Title LIKE'%"&trim(request("Title"))&"%' or Spec='"&trim(request("Spec"))&"' or Title='"&trim(request("pinming"))&"')  and id  in (select max(id) from Hover_Product group by Title) order by ArticleID desc"