OraFAQ Forum: SQL & PL/SQL » Top two maximun dates -Urgent

Home » SQL & PL/SQL » SQL & PL/SQL » Top two maximun dates -Urgent

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Top two maximun dates -Urgent [message #21732]

Mon, 26 August 2002 19:06

UmaSund
Messages: 22
Registered: February 2002

Junior Member

Hi

I have column with dates in them . I need to identify the second most max date. I can Identify the Max date by using the max function. How do I identify the second most max date?

How can this be achieved?

Thanks a ton in advance.

-Umasund

Report message to a moderator

Re: Top two maximun dates -Urgent [message #21734 is a reply to message #21732]

Mon, 26 August 2002 21:50

Raj
Messages: 411
Registered: November 1998

Senior Member

hi,
the following query solves u'r problem.

select min(start_date) from test a where 2 >(select count(*) from test b where a.start_date<b.start_date)

Report message to a moderator

Re: Top two maximun dates -Urgent [message #21743 is a reply to message #21732]

Tue, 27 August 2002 08:20

UmaSund
Messages: 22
Registered: February 2002

Junior Member

Thank you Raj, Todd and Manju for your replies

Problem solved.
-Umasund

Report message to a moderator

Previous Topic:	Row counter on multi-table view or query
Next Topic:	SQL Output

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 11:21:13 CDT 2024