RE: SQL Query (fwd)

What's the logic behind your query????

Sandeep

-----Original Message-----
From: Pallav Kalva [mailto:pallav_at_starmedia.net] Sent: Monday, June 26, 2000 12:58 PM
To: Multiple recipients of list ORACLE-L Subject: SQL Query (fwd)

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 ???

Thanks!
Pallav

-- 
Author: Pallav Kalva
  INET: pallav_at_starmedia.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).