与“SELECT DISTINCT”相反“ [英] Opposite of "SELECT DISTINCT"

问题描述

任何想法如何运行一些不会选择distinct的SQL，但会选择不同的值。或类似选择重复

Any idea how to run some SQL that would not Select distinct, but would select the values that are not distinct. Or something like "Select Duplicate"

推荐答案

我认为关键字COUNT虽然我忘了语法，但在这种情况下可能会有用...

I think the keyword "COUNT" might be useful in this situation, though I forget the syntax...

http://www.petefreitag.com/item/169.cfm


这说它比我更好

http://www.petefreitag.com/item/169.cfm

That says it better than I can

Blyxx86，


我担心你的问题不是很清楚。

如果你能用明确的术语改写它我让你拥有你想要的东西。


-Adrian。

Blyxx86,

I''m afraid your question is not very clear.
If you can rephrase it in clear terms I''ll let you have what you''re looking for.

-Adrian.

这篇关于与“SELECT DISTINCT”相反“的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！