Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How fo you return the SECOND highest record?
You may try something like
select * from <table_name> where datetime < (select max(datetime) from <table_name>);
HTH,
Paul
<vivarin_at_my-deja.com> wrote in message news:91uad8$6qm$1_at_nnrp1.deja.com...
> I am stumped and would appreciate it if anyone
> could help me. Perhaps the answer is obvious.
> Anyways, I have a table with 3 columns like so:
>
> 1. (numeric unique key) PK
> 2. (dateime) DATE
> 3. (number) NUM
>
> The 3rd column, is NOT unique.
>
> Anyways, I want to return all recordsets that
> have the second most recent DATE grouped by NUM,
> as opposed to the most recent date. I've tried
> various ways to join a table to itself but I'm
> finding myself running into syntactical
> difficulties. I know you can use a subquery with
> a NOT IN clause, but I want to avoid that, and
> perhaps use an outer join. Anyways, any help
> would definitely be appreciated!!! Thanks
>
> JJY
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Dec 21 2000 - 22:57:02 CST