select ClassName,Title from article,class
where class.ClassID=article.ClassID and (
article.ArticleID in(select top 2 ArticleID from article where ClassID=1 order by ArticleID desc)
or article.ClassID<>1 --非ID为1情况 可为1、2、3、4……
)
string sql2 = "select X_Article.ArticleID,X_Article.ClassID,X_Article.Title,X_Article.UpdateTime from X_Article where X_Article.ClassID in(select X_Article.ClassID from X_Article where X_Article.ClassID in(select X_Class.ClassID from X_Class where X_Class.ShowOnIndex = -1) group by X_Article.ClassID having count(*)<5)";
select ClassName,article.Title from article,class
where class.ClassID=article.ClassID and (
article.ArticleID in(select top 2 ArticleID from article where ClassID=1 order by ArticleID desc)
or article.ClassID=2
)
string sql2 = "select * from X_Class,X_Article where Exists(Select * from X_Class,X_Article Where X_Class.ClassID = X_Article.ClassID Having Count(*)<5)";
这是借鉴网上的,但是执行不了:(
select ClassName,article.Title from article,class
where class.ClassID=article.ClassID and (
article.ArticleID in(select top 2 ArticleID from article where ClassID=1 order by ArticleID desc)
or article.ClassID=2
)
我精简一下
select ClassName,article.Title from article,class
where class.ClassID=article.ClassID and (
article.ArticleID in(select top 2 ArticleID from article where ClassID=1)
or article.ClassID=2
)