SQL Query

Hi Guys,

I have a table ABC with 2 columns like

Date          Values
----          ------

22-JUN-00       1

22-JUN-00       2

.

.

23-JUN-00 5 23-JUN-00 6 I want the result to be

OLD_DATE       VAL         NEW_DATE     VAL
--------       ---         --------     ---
22-JUN-00       1          23-JUN-00     5

22-JUN-00       2          23-JUN-00     6 

Is there any simpler way to do that ??? Received on Fri Jun 23 2000 - 20:00:21 CDT