Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sql
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.
Received on Tue Sep 24 2002 - 08:18:04 CDT