RE: Select DISTINCT question

Beth is correct in her statement. I'm sorry if some of my responses to this question are getting cut off but the network people are working on upgrading the email service. listed is my response to tom that was clipped by the email server.
—---
Rick,
You are correct. Both statements will return the same results. It could be the wrong results depending on the circumstances. Duplicate records will not show up. An ORDER BY is needed for that in this situation. Distinct and group by remove the duplicates.. Ron

>>> Beth.Seefelt_at_TetleyUSA.com 02/06/02 01:28PM >>>

I think he just misread the "group by" as an "order by"

trailer infor removed-------
Ron

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).