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: GROUP BY .. on calculated field

Re: SQL: GROUP BY .. on calculated field

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Wed, 24 Dec 2003 22:17:31 -0500
Message-ID: <kklkuv4j3biqh90vad9bkobc5siruu7reo@4ax.com>


On Wed, 24 Dec 2003 13:09:46 +0300, Vadim Grepan <_RMV_IT_kezal_at_mail.ru> wrote:

>Myself I prefer way (1). Is there any benefit for way (2) ?

Interesting. I've never thought of way #1, using a subselect to factor out the calculation. That's a clever approach.

Jonathan Gennick --- Brighten the corner where you are http://Gennick.com

Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to Oracle-article-request_at_gennick.com and include the word "subscribe" in either the subject or body. Received on Wed Dec 24 2003 - 21:17:31 CST

Original text of this message

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