Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> OT/HUMOR RE: ORDER BY ..
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C048D8.82B29DB0
Content-Type: text/plain;
charset="iso-8859-1"
this was just covered in a recent series of posts.
You must use
make_ORDER_BY_clause= {slow|normal|quick|very quick} ( pick one )
-----Original Message-----
From: Marcos.Vera_at_msconsultores.com.pe
[mailto:Marcos.Vera_at_msconsultores.com.pe]
Sent: Tuesday, November 07, 2000 10:26 AM
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
> -----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 ListsReceived on Tue Nov 07 2000 - 10:36:55 CST
--------------------------------------------------------------------
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).
------_=_NextPart_001_01C048D8.82B29DB0
Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>OT/HUMOR RE: ORDER BY ..</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>this was just covered in a recent series of posts. = </FONT> </P> <P><FONT SIZE=3D2>You must use</FONT> </P> <P><FONT SIZE=3D2>make_ORDER_BY_clause=3D {slow|normal|quick|very = quick} ( pick one ) = </FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Marcos.Vera_at_msconsultores.com.pe</FONT> <BR><FONT SIZE=3D2>[<A = HREF=3D"mailto:Marcos.Vera_at_msconsultores.com.pe">mailto:Marcos.Vera_at_msco= nsultores.com.pe</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Tuesday, November 07, 2000 10:26 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: ORDER BY ..</FONT> </P> <BR> <BR> <BR> <BR> <P><FONT SIZE=3D2>i want my 'order by' transaction to be quick...very = quick ...</FONT> <BR><FONT SIZE=3D2>what oracle parameter should i increase or decrease = ???</FONT> </P> <P><FONT SIZE=3D2>Thanks a lot .</FONT> </P> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <P><FONT SIZE=3D2>"bunyamin karadeniz" = <bunyamink_at_havelsan.com.tr> on 07/11/2000 02:55:22 AM</FONT> </P> <P><FONT SIZE=3D2>Please respond to ORACLE-L_at_fatcity.com</FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> </P> <BR> <P><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> <BR><FONT SIZE=3D2> To: Multiple = recipients of list = ORACLE-L &nbs= p; </FONT> <BR><FONT = SIZE=3D2> = <ORACLE-L_at_fatcity.com> &n= bsp; &n= bsp; </FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> <BR><FONT SIZE=3D2> cc: (bcc: Marcos = Vera/M&S = Consultores/51) &nb= sp; </FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> <BR><FONT SIZE=3D2> Subject: Re: Query to select only the = duplicate records from </FONT> <BR><FONT = SIZE=3D2> a = table? = = = </FONT> <BR><FONT = SIZE=3D2> &nb= sp; &nb= sp; &nb= sp; &nb= sp; &nb= sp; </FONT> </P> <BR> <BR> <BR> <BR> <BR> <BR> <P><FONT SIZE=3D2>SELECT interested_columns</FONT> <BR><FONT SIZE=3D2>FROM table_name a</FONT> <BR><FONT SIZE=3D2>WHERE rowid >(SELECT min(rowid)</FONT> <BR><FONT SIZE=3D2>FROM table_name b</FONT> <BR><FONT SIZE=3D2>WHERE b.pk_column =3D a.pk_column ) ;</FONT> </P> <P><FONT SIZE=3D2>*pk_coloumn is the primary key column the = table.</FONT> <BR><FONT SIZE=3D2>if you want to delete the duplicate rows, just = change the select to DELETE</FONT> </P> <P><FONT SIZE=3D2>****** if you want to leave only one row of the = duplicated rows,For ex: you</FONT> <BR><FONT SIZE=3D2>have 3 duplicated rows and want to delete 2 of them = and leave only one, The</FONT> <BR><FONT SIZE=3D2>only possibility as I understand is first selecting = the duplicate rows with</FONT> <BR><FONT SIZE=3D2>DISTINCT and then insert into another table = and then delete duplicated rows</FONT> <BR><FONT SIZE=3D2>from the base table and select from second table and = insert into base</FONT> <BR><FONT SIZE=3D2>table.******</FONT> </P> <BR> <P><FONT SIZE=3D2>**********************************************</FONT> <BR><FONT SIZE=3D2>Bunyamin K. Karadeniz</FONT> <BR><FONT SIZE=3D2>Enformasyon Teknolojileri Dir.</FONT> <BR><FONT SIZE=3D2>Veri Tabani Grubu tel : 2873565/1681</FONT> <BR><FONT SIZE=3D2>HAVELSAN</FONT> <BR><FONT = SIZE=3D2>**********************************************</FONT> </P> <P><FONT SIZE=3D2>> -----Original Message-----</FONT> <BR><FONT SIZE=3D2>> To: Multiple recipients of list ORACLE-L = <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2>> Date: Monday, November 06, 2000 2:38 PM</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> >Hello Lists,</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> >Can any body help me in writing a query = which will</FONT> <BR><FONT SIZE=3D2>> >list only the duplicate records from a = table?</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> >Any help would be highly = appreciated.</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> >TIA,</FONT> <BR><FONT SIZE=3D2>> >Muru</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> = >__________________________________________________</FONT> <BR><FONT SIZE=3D2>> >Do You Yahoo!?</FONT> <BR><FONT SIZE=3D2>> >Thousands of Stores. Millions of = Products. All in one Place.</FONT> <BR><FONT SIZE=3D2>> ><A HREF=3D"http://shopping.yahoo.com/" = TARGET=3D"_blank">http://shopping.yahoo.com/</A></FONT> <BR><FONT SIZE=3D2>> >--</FONT> <BR><FONT SIZE=3D2>> >Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>> >--</FONT> <BR><FONT SIZE=3D2>> >Author: Murugesan Balakrishnan</FONT> <BR><FONT SIZE=3D2>> > INET: mail_oracle_at_yahoo.com</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> >Fat City Network Services = -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> >San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>> = >--------------------------------------------------------------------= </FONT> <BR><FONT SIZE=3D2>> >To REMOVE yourself from this mailing list, = send an E-Mail message</FONT> <BR><FONT SIZE=3D2>> >to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> >the message BODY, include a line = containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> >(or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>> >also send the HELP command for other = information (like subscribing).</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Author: Jim Walski</FONT> <BR><FONT SIZE=3D2>> INET: = jwalski3_at_classicplan.com</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>> =
--------------------------------------------------------------------</FO=
NT> <BR><FONT SIZE=3D2>> To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>> to: ListGuru_at_fatcity.com (note EXACT spelling = of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> (or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>> also send the HELP command for other = information (like subscribing).</FONT> </P> <P><FONT SIZE=3D2>--</FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>--</FONT> <BR><FONT SIZE=3D2>Author: bunyamin karadeniz</FONT> <BR><FONT SIZE=3D2> INET: bunyamink_at_havelsan.com.tr</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from). You may</FONT> <BR><FONT SIZE=3D2>also send the HELP command for other information = (like subscribing).</FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: </FONT> <BR><FONT SIZE=3D2> INET: Marcos.Vera_at_msconsultores.com.pe</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
![]() |
![]() |