sql去重

来源:互联网 发布:淘宝全屏居中代码 编辑:程序博客网 时间:2024/04/26 13:29
        string _strSql = "SELECT TOP 6 * FROM (SELECT distinct ArticleID,Title,TitlePic,Discription,UrlAddr,UrlFlag FROM QB_VIEW_ChannelArticleTagRelation WHERE TypeID=" + TagTypeID + ") A ORDER BY ArticleID DESC";