Re: sql

Hello,

abhishek schrieb:
> how to write sql querry to
> 1. show the second maximum value of a column.

I think that will work ...

SELECT * from (SELECT * from MyTable ORDER by RowName) WHERE ROWNUM=2

Greetings from Rostock, Germany!

Tino

-- 
Tino Korth                               Registered Linux User #286417
www.tinokorth.de - ICQ 10771191                  http://counter.li.org