SELECT * FROM dbo.Article INNER JOIN dbo.Cases ON dbo.Cases.customer_id=dbo.Article.Id
这句SQL语句中表dbo.Article中有一列Title,我要使这句sql语句查出得结果中,Title里的数据是不重复的!
第一个回答并正确的,40满分!哪位大哥帮帮忙啊!小弟,感激感激!!
这句SQL语句中表dbo.Article中有一列Title,我要使这句sql语句查出得结果中,Title里的数据是不重复的!
第一个回答并正确的,40满分!哪位大哥帮帮忙啊!小弟,感激感激!!
FROM dbo.Article INNER JOIN dbo.Cases
ON dbo.Cases.customer_id=dbo.Article.Id
(
SELECT * FROM dbo.Article INNER JOIN dbo.Cases ON dbo.Cases.customer_id=dbo.Article.Id
) as t where article.id in
(
select atricle.id
from
(
SELECT max(atricle.id) FROM dbo.Article INNER JOIN dbo.Cases ON dbo.Cases.customer_id=dbo.Article.Id
) as t group by title
)
(
SELECT * FROM dbo.Article INNER JOIN dbo.Cases ON dbo.Cases.customer_id=dbo.Article.Id
) as t where article.id in
(
select max(atricle.id)
from
(
SELECT * FROM dbo.Article INNER JOIN dbo.Cases ON dbo.Cases.customer_id=dbo.Article.Id
) as t group by title
)