Home » SQL & PL/SQL » SQL & PL/SQL » an interesting query
an interesting query [message #251042] Thu, 12 July 2007 04:45 Go to next message
p.bhaskar
Messages: 33
Registered: February 2007
Location: kolkata
Member
i hve data like this -------->

CASE_ID ACTION DT
--------------------------------------------------
1227626 Assigned case to FixerGroup 5/17/2007
1227626 Case Note 5/18/2007
1227626 Assigned case to FixerGroup 5/18/2007
1227626 Case Note 5/22/2007
1227626 Assigned case to FixerGroup 5/23/2007
1227626 Case Note 5/24/2007
1227626 Assigned case to FixerGroup 5/24/2007
1227626 Case Note 5/25/2007


now i want o/p like this------------>

CASE_ID DT_Received DT_Actioned
--------------------------------
1227626 17.05.2007 18.05.2007
1227626 18.05.2007 22.05.2007
1227626 23.05.2007 24.05.2007
1227626 24.05.2007 25.05.2007
Re: an interesting query [message #251045 is a reply to message #251042] Thu, 12 July 2007 04:52 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
http://www.orafaq.com/forum/fa/448/0/

Closed. Continue here.

MHE
Previous Topic: SQL query needed
Next Topic: droping more than one table using pl/sql
Goto Forum:
  


Current Time: Wed Dec 07 06:43:03 CST 2016

Total time taken to generate the page: 0.10501 seconds