|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
You don't need a fax machine to get faxes. Get a fax-to-email fax number from CallWave. Try it free.
|
|
#1
|
|||
|
|||
|
I need a little help with the following problem:
I would like to have a result set containing all entries of one table that are not distinct. e.g.: SELECT DISTINCT value FROM table value ------- abc def ghi SELECT value FROM table value ------- abc abc def ghi ghi What I need is a statement that returns something like this: value ------- abc ghi Any ideas? Thanks! |
|
#2
|
|||
|
|||
|
select value, count(*)
from table group by value having count(*) > 1 |
|
#3
|
|||
|
|||
|
...that's it.
Thanks, that does the job!
Chris. ![]() |
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > sql-query distinct entries |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|