How to get one version of the duplicates only

[swedee]

After performing a question with MySQL I have an answer with duplicates or triplets and quadruples and so on...

I need to extract one of the duplicates for example...

I receive the followng vector for example after doing one SELECT

|1|2|2|3|4|5|5|6|

I need to get |2|5|

And I need to do it with SQl-questions only... is it possible...

If I us ethe same SQL-string but with DESTINCT I would get

|1|2|3|4|5|6|

But I need the omitted ones

Can anyone help?

/Johan

[zhabala]

SELECT DISTINCT grouped_field FROM table GROUP BY grouped_field HAVING COUNT(*) > 1

Zdenek

[swedee]

Thank you for your reply Seems very short and neat. Excuse my ignorance but what is the "grouped_field"?

[zhabala]

It is the name for column where the duplicates should be found. I used it because you did not mentioned your SELECT statement exactly.

Zdenek

[swedee]

Tjohooo!!!

I managed.... Thanks man... you are the maaaaaan

Appreciate it man!

Thanks