RE: Select DISTINCT to be avoided?

Here's one take on the matter:

http://www.toadworld.com/KNOWLEDGE/KnowledgeXpertforOracle/tabid/648/TopicID/TSQ419/Default.aspx

From: [email protected] [mailto:[email protected]] On Behalf Of Madvig, Daniel B
Sent: Tuesday, October 11, 2011 11:02 AM
To: [email protected]
Subject: [toad] Select DISTINCT to be avoided?


I realize I should probably ask on ToadSQL, but the topic came up here.

So, is there a treatise somewhere on what to use instead that's understandable by mere mortals?

Thanks much,

Dan

Daniel B Madvig
Computer Technologies

[cid:[email protected]]<http://nwc.edu/>

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu<http://maps.yahoo.com/py/maps.py?Pyt=Tmap&addr=3003+Snelling+Ave.&csz=St.+Paul%2C+MN+55113&country=us>
651.631.5323