Re: how can i find out the second maximum value from a table by sql

sohelcsc_at_yahoo.com (Leader) wrote in message news:<b1a93c73.0202132336.4191d0e6_at_posting.google.com>...
> Hi all,
> How can i find out the second maximum value from a table by sql.
>
>
> thanks
> Hoque
Hi,

It's simple

SQL> create table table_name (field_name number);

Table created.

SQL> insert into table_name values (1);

1 row created.

SQL> insert into table_name values (2);

1 row created.

SQL> insert into table_name values (3);

1 row created.

SQL> insert into table_name values (4);

1 row created.

SQL> insert into table_name values (7);

1 row created.

SQL> insert into table_name values (9);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from table_name;

FIELD_NAME

         1
         2
         3
         4
         7
         9

6 rows selected.

SQL>
  1 select min(field_name) from (
  2 select field_name from table_name order by field_name desc   3* ) where rownum < 3
  4 /

MIN(FIELD_NAME)

              7

Regards,
  Sergiy Meshkov Received on Thu Feb 14 2002 - 14:54:38 CET