RE: ORDER BY ..

From: lerobe - Lee Robertson <LEROBE_at_acxiom.co.uk>
Date: Tue, 7 Nov 2000 16:31:21 -0000
Message-Id: <10673.121310@fatcity.com>

GO ON - I DARE ONE OF YOU !!!!! -----Original Message-----
From: Marcos.Vera_at_msconsultores.com.pe
[mailto:Marcos.Vera_at_msconsultores.com.pe] Sent: 07 November 2000 15:26
To: Multiple recipients of list ORACLE-L Subject: ORDER BY ..

i want my 'order by' transaction to be quick...very quick ... what oracle parameter should i increase or decrease ???

Thanks a lot .

"bunyamin karadeniz" <bunyamink_at_havelsan.com.tr> on 07/11/2000 02:55:22 AM

Please respond to ORACLE-L_at_fatcity.com

                                                              
                                                              
                                                              
 To:      Multiple recipients of list ORACLE-L                
          <ORACLE-L_at_fatcity.com>                              
                                                              
 cc:      (bcc: Marcos Vera/M&S Consultores/51)               
                                                              
                                                              
                                                              
 Subject: Re: Query to select only the duplicate records from 
          a table?

SELECT interested_columns
FROM table_name a
WHERE rowid >(SELECT min(rowid)
FROM table_name b
WHERE b.pk_column = a.pk_column ) ;

*pk_coloumn is the primary key column the table. if you want to delete the duplicate rows, just change the select to DELETE

if you want to leave only one row of the duplicated rows,For ex: you have 3 duplicated rows and want to delete 2 of them and leave only one, The only possibility as I understand is first selecting the duplicate rows with DISTINCT and then insert into another table and then delete duplicated rows from the base table and select from second table and insert into base table.******

Bunyamin K. Karadeniz
Enformasyon Teknolojileri Dir.
Veri Tabani Grubu tel : 2873565/1681
HAVELSAN

> -----Original Message-----

> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Date: Monday, November 06, 2000 2:38 PM
>
>
> >Hello Lists,
> >
> >Can any body help me in writing a query which will
> >list only the duplicate records from a table?
> >
> >Any help would be highly appreciated.
> >
> >TIA,
> >Muru
> >
> >__________________________________________________
> >Do You Yahoo!?
> >Thousands of Stores.  Millions of Products.  All in one Place.
> >http://shopping.yahoo.com/
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Murugesan Balakrishnan
> >  INET: mail_oracle_at_yahoo.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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jim Walski
>   INET: jwalski3_at_classicplan.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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: bunyamin karadeniz
  INET: bunyamink_at_havelsan.com.tr

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: Marcos.Vera_at_msconsultores.com.pe

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).


The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader 
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  
If you have received this communication in error, please

Received on Tue Nov 07 2000 - 10:31:21 CST