How to find second max date?

[ales]

If you have Oracle without analytic function:

* to find second max date:

select max(hiredate) from emp
where hiredate<(select max(hiredate) from emp)

* to find second min date:

select min(hiredate) from emp
where hiredate>(select min(hiredate) from emp)