List Duplicate results

[l!m!t]

Hello,

 

I cant seem to figure out how I can list duplicate results from the same row.

 

For example I want to list all the duplicate "model_numbers" within my "model_number" row. I found examples how to count them using "group by", but I want to list only the duplicates individually  not count them.

 

Any example how to do this would be great - my basic query minus the "while loop".

 

select model_number from mytable order by model_number ASC  

 

I only want to retrieve duplicate model numbers and then list them.

 

Any help would be great.

[kickstart]

Hi

 

Try something like this

 

select model_number, COUNT(*) AS model_Count
from mytable 
GROUP BY model_number
HAVING model_Count >1
order by model_number ASC 

 

All the best

 

Keith