Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL: GROUP BY .. on calculated field
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