Re: sql

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 24 Sep 2002 16:07:26 GMT
Message-ID: <3D908DB2.A32D71FA@exesolutions.com>

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