Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: sql question help

Re: sql question help

From: Herod <herodt_at_gmail.com>
Date: 10 Mar 2006 21:34:29 -0800
Message-ID: <1142055269.757947.20240@i40g2000cwc.googlegroups.com> 





get rid of distinct.  Of no use, pretty much ever.



group by upper(state_name) instead.



For your next day in class, remember - always group by what you show
that you don't have a function on (sum,avg,count etc) always.
Exactly.
Received on Fri Mar 10 2006 - 23:34:29 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US