RE: rewrite group by query

From: Rohan Karanjawala <rohanjava_at_hotmail.com>
Date: Tue, 06 Jan 2004 02:05:23 -0800
Message-ID: <F001.005DBBD3.20040106020523@fatcity.com>

try this out
select a, b
from (select a from tab1 group by a having count(*)=1) alias where a in alias;

regds,

Rohan

>From: "elain he" <elainhe_at_hotmail.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: rewrite group by query
>Date: Mon, 05 Jan 2004 07:24:25 -0800
>
>Hi,
>Does anyone have a better way of rewriting the following query? I'm trying
>to avoid querying the table, tab1 twice.
>
>select a, b from tab1
>where a in (select a from tab1 group by a having count(*)=1);
>
>
>Thanks.
>
>elain
>
>_________________________________________________________________
>Make your home warm and cozy this winter with tips from MSN House & Home.
>http://special.msn.com/home/warmhome.armx
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: elain he
> INET: elainhe_at_hotmail.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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).

---

Games, MMS cards, ringtones. Operator logos, picture messages & more. http://server1.msn.co.in/sp03/mobilesms/ Jazz up your mobile!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rohan Karanjawala
  INET: rohanjava_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Tue Jan 06 2004 - 04:05:23 CST