Hi all

Can I display Nearest dates before 31-dec-2002 from the table?
my data table shows this..
P_REF P_ID P_DT P_RSN
---------- ---------- --------- -------
D052 1916 24-JUL-00 new
d052 2779 04-JAN-01 act
d052 5156 01-OCT-02 act
d053 1920 24-JUL-00 new
d053 3134 09-MAY-01 act
d053 4587 11-OCT-02 act

here nearest dates to 31-dec-02 are 01-oct-02 and 11-oct-02
How to get these dates with the help of sql query?

awaiting reply...

thanks in advance
Ami