RE: help with query :)

From: Jane Gao <JGao_at_kalgold.com.au>
Date: Wed, 31 May 2000 14:38:57 +0800
Message-Id: <10513.107210@fatcity.com>

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_01BFCACA.E5FAD00C
Content-Type: text/plain

Try this query:

select * from yourtable minus
(select * from yourtable where rownum <= (select count(*) - 5 from yourtable));

Hope it helps

Jane Gao
Senior Application Support Analyst
Kalgoorlie Consolidated Gold Mines

> * Phone : (08) 9022 1129

*Fax		:  (08) 9022 1119


> *Address	:  PMB 27

		    KALGOORLIE  WA  6430


> *E-mail	:  jgao_at_kalgold.com.au

>
>
> -----Original Message-----
> From: Yohans Mendoza [SMTP:yohans_at_demiurge.sirius-images.net]
> Sent: Wed, 31 May 2000 08:25
> To: Multiple recipients of list ORACLE-L
> Subject: help with query :)
>
> hi all,
>
> hope you're ok
> I have this "silly" question. Is there an easy way to retrieve the last 10
> records that have been entered in a given table?
>
> TIA
>
> --Yohans
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~~~~~
> Yohans Mendoza System Analyst
> yohans_at_sirius-images.com Sirius Images Inc.
> http://www.sirius-images.net/users/yohans http://www.sirius-images.com
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~~~~~
>
> --
> Author: Yohans Mendoza
> INET: yohans_at_demiurge.sirius-images.net
>
> 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_01BFCACA.E5FAD00C
Content-Type: text/html
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=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0">

<TITLE>RE: help with query :)</TITLE>
</HEAD>
<BODY>

Try this = query:

select * from = yourtable minus 
 (select * from = yourtable where rownum <=3D (select count(*) - 5 from = yourtable));

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Hope it helps =
</FONT>
</P>

Jane Gao

<BR><B><FONT SIZE=3D2 FACE=3D"Tahoma">Senior Application Support =
Analyst</FONT></B>
<BR><B><FONT SIZE=3D2 FACE=3D"Tahoma">Kalgoorlie Consolidated Gold =

Mines
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=
------------------</FONT></B>

( Phone :  (08) 9022 1129 .Fax    =         :  (08) 9022 = 1119
 +Address        = :  PMB 27
         =             KALGOORLIE  WA  = 6430
 *E-mail :  jgao_at_kalgold.com.au

</P>
<BR>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =

SIZE=3D1 FACE=3D"Arial">Yohans Mendoza = [SMTP:yohans_at_demiurge.sirius-images.net] Sent:   Wed, 31 May 2000 08:25 To:     Multiple recipients of list ORACLE-L Subject:       = help with query :)

hi all,

hope you're ok I have this "silly" = question. Is there an easy way to retrieve the last 10 records that have been entered in a = given table?

TIA

--Yohans <FONT SIZE=3D2 =

FACE=3D"Arial">~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~=
~~~~~~~~~~~~~~~~~~~~~~</FONT>

Yohans Mendoza  =

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System Analyst</FONT>

yohans_at_sirius-images.com     &nb= sp;          =         Sirius Images = Inc.      <A =
HREF=3D"http://www.sirius-images.net/users/yohans" = TARGET=3D"_blank">http://www.sirius-images.net/users/yohans</A> &nb= sp;     <A HREF=3D"http://www.sirius-images.com" = TARGET=3D"_blank">http://www.sirius-images.com</A> <FONT SIZE=3D2 =

FACE=3D"Arial">~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~=
~~~~~~~~~~~~~~~~~~~~~~</FONT>

<P><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Yohans Mendoza</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =

yohans_at_demiurge.sirius-images.net

Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 San Diego, = California        -- Public Internet = access / Mailing Lists
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

-----------
 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 Received on Wed May 31 2000 - 01:38:57 CDT