How to display duplicate values contained in a column

[jasperjasper]

I need to create a stored procedure to display all duplicate values that are in a column. In the following list I need to display the duplicate values --- which in this case is 543211. Can anyone give me a clue on how to accomplish this in SQL via a stored proc. Thanks

VendInv#
--------
000001
000002
543211
040400
543211
888838

 

[r937]

select [VendInv#]
from yourtable
group by [VendInv#]
having count(*) > 1


rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[jasperjasper]

WOW...Great. That is correct. Thank you so much.
I should have known that.