找到另一个列至少有两个不同值的id

I have this:

我有这个:

SELECT DocumentID
FROM
(
SELECT DocumentID, Extension FROM Pages
GROUP BY DocumentID, Extension HAVING ( Count(1) > 2 )
) MultiplePages
GROUP BY MultiplePages.DocumentID Having ( Count(1) > 1 )

I am looking for a result set of Documents that have multiple pages where the pages do not share a distinct extension. This query works but I was wondering if there was a better way.

我正在寻找具有多个页面的文档的结果集，这些页面不共享不同的扩展。这个查询有效，但我想知道是否有更好的方法。

Also, I am new to Stack Overflow and I am open to suggestions on creating better titles, descriptions, or how I might have searched for this question. Thanks.

此外，我是Stack Overflow的新成员，我愿意为创建更好的标题、描述或如何搜索这个问题提供建议。谢谢。

1 个解决方案

#1

SELECT DocumentID
FROM Pages
GROUP BY DocumentID
HAVING COUNT(DISTINCT(Extension)) > 1

或

SELECT DocumentID
FROM Pages
GROUP BY DocumentID
HAVING MIN(Extension) <> MAX(Extension)

1 个解决方案

#1

更多相关文章

随机推荐