OraFAQ Forum: SQL & PL/SQL » fetch second maximum record

Home » SQL & PL/SQL » SQL & PL/SQL » fetch second maximum record

Fri, 12 March 2004 21:27

ADHISH KUNDU
Messages: 2
Registered: March 2004

Junior Member

I want to fetch second maximum age from the employee table.please tell me the sql query regarding the above mentioned problem.

Fri, 12 March 2004 21:56

Rishi
Messages: 63
Registered: January 2001

Member

select max(age) from emp
where age not in (select max(age) from emp);

Previous Topic:	Materialized views
Next Topic:	OUTER JOIN

Goto Forum:

]

Current Time: Fri Apr 19 22:17:06 CDT 2024