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 -> Use of Column Alias in GROUP BY

Use of Column Alias in GROUP BY

From: GHouck <hksys_at_teleport.com>
Date: 1998/12/14
Message-ID: <367491EF.7100@teleport.com>#1/1

In the following query, since it appears that you cannot use a column alias in either a GROUP BY or HAVING clause, is there avoidable/unavoidable overhead in referring to the Function SECTION(..) or COUNT(..) more than once?

Are the results of the 'calls' cached to offset the multiple calls?

SELECT
  SECTION(MAPNO) AS "SEC", COUNT(*) AS "KNT" FROM
  UTIL_POLES
GROUP BY
  SECTION(MAPNO)
HAVING
  COUNT(*) > 1
ORDER BY
  KNT,SEC; Is there an alternative method?

Thanks,

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Mon Dec 14 1998 - 00:00:00 CST

Original text of this message

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