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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Subquery

Re: Subquery

From: <dgoulet_at_vicr.com>
Date: Tue, 29 May 2001 05:26:20 -0700
Message-ID: <F001.00311A9F.20010529051151@fatcity.com>

 Why would you want to use a subquery? I can see no reason or it and they do tend to slow things down.

Dick Goulet

---------------------- Reply Separator ----------------------
Author: Roland.Skoldblom_at_ica.se
Date: 5/29/01 4:15 AM

Hallo you DBAs

How can I write this sql query using subqueries?

SELECT pbk.nielsenart.varunamn, pbk.nielsenart.strl, pbk.nielsenart.varutxt,
null, pbk.nielsenart.vgrp, rik2.hierarki_tekst.tekst, null, pbk.sortiment_vgrp.sortiment, pbk.nielsenart.art_grp, pbk.nielsenart.art_ugrp,
null
FROM pbk.nielsenart,pbk.sortiment_vgrp,rik2.hierarki_tekst, pbk.rapporttmp
WHERE pbk.nielsenart.vgrp=rik2.hierarki_tekst.vgrp

AND pbk.sortiment_vgrp.vgrp=pbk.nielsenart.vgrp
AND rik2.hierarki_tekst.sett_id=2
AND rik2.hierarki_tekst.landkode=46

AND pbk.nielsenart.ean=pbk.rapporttmp.EAN AND ROWNUM=1 Roland Sköldblom
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Roland.Skoldblom_at_ica.se

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet_at_vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 May 29 2001 - 07:26:20 CDT

Original text of this message

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