I have got two questions.I am trying generate a sql which gives me a Begin time and Ending time.The Data is something like this.
id eid datetime action
15172887 102517 11/18/2004 11:34:47 PM Started Call
15172888 102517 11/18/2004 11:35:36 PM Closed Issue
15172889 102517 11/18/2004 11:35:36 PM Closed Call
Begin Time can be re-opened call,started call,opened call
Ending Time can be Closed call
The call can be attended by multiple persons
for ex :-
I want the begin time and end time of ddd for a particualr id.
Please help me out.I need to fix this today.
It Should be displayed something like this
id begin time End Time
1111 11/18/2004 11:34:47 PM 11/18/2004 11:35:36 PM
My Second Question
My second question associated with the first.
i have got columns called product,agent which depends on the id
The data is something like this
I need it to display in the following format
Please get me a solution for these two questions.
Last edited by mys; 11-30-2004 at 05:35 AM.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Please help me out on this query,i am trying all the resource not getting the solution
Really? Perhaps you could show us what doesn't work.
Originally posted by mys
. . .i am trying all the resource not getting the solution
Q1: is totally incomprehensible
Q2: search for "pivot" here: http://asktom.oracle.com/
Click Here to Expand Forum to Full Width