> I can do it in Sybase with the following SQL:
> Select RecID, ID, NAME From MyTable
> Where ID in (Select ID From MyTable Group By NAME Having count(*) > 1)
> Order By NAME
Actually I think I goofed, just to correct this:
Select RecID, ID, NAME From MyTable
Where NAME in (Select NAME From MyTable Group By NAME Having count(*) > 1)
Order By NAME
-Frank
=====
Frank Schima <mailto:macsforever2000 .at. yahoo .DOT com>
Yahoo Messenger Chat <macsforever2000>
INADEV Consulting Inc. <http://www.inadev.com/>
Columbia, MD USA <http://columbiamaryland.com/>
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
-------------------------------------------------------------
The Valentina mailing list is brought to you by MacServe.net
For info on lists services, see http://www.macserve.net/lists.html
©2001 Frank Schima |
