Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sql
Brian E Dick wrote:
> select max(c) from (select c from t where c < (select max(c) from t))
>
> "abhishek" <singhhome_at_yahoo.com> wrote in message
> news:e52380ab.0209232324.24bd2cbd_at_posting.google.com...
> > how to write sql querry to
> > 1. show the second maximum value of a column.
Fascinating. I like it.
Now to explain plan them all.
Thanks everyone for the material. My students, in a few weeks, will thank you too. (I think)
Daniel Morgan Received on Tue Sep 24 2002 - 11:07:26 CDT
![]() |
![]() |