Re: sql

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

You could use a self join:

select max (A.<YOURCOL>)
  from <YOURTABLE> A, <YOURTABLE> B
  where A.<YOURCOL> < B.<YOURCOL>

-- 
Due to spam, this email address is only used for newsgroup postings.

All emails sent to this address are immediately deleted. Therefore any
eMails sent directly to this address never will be answered.

Mit freundlichen Grüßen / Best Regards
Michael Gast
SEPP MED GmbH