Please Any help in writing this query [message #23397] |
Thu, 05 December 2002 04:39 |
rao
Messages: 25 Registered: July 1999
|
Junior Member |
|
|
Any help on writing this query
I have a table like below
Order- plan- parent- istask- status
1- p1- null- N- null
2 null 1 Y Due
3 null 1 Y OverDue
4 p2 null N null
5 null 4 Y Due
6 null 4 Y OverDue
7 p1 null N null
8 null 7 Y Due
9 null 7 Y Due
10 p2 null N null
11 null 10 Y Due
12 null 10 Y OverDue
My output should like below
Plan Due OverDue
p1 3 1
p2 2 2
Many Thanks In Advance
Rao
|
|
|
Re: Please Any help in writing this query [message #23399 is a reply to message #23397] |
Thu, 05 December 2002 06:09 |
Jon
Messages: 483 Registered: May 2001
|
Senior Member |
|
|
SQL> select plan, sum(decode(status,'Due',1,0)) Due, sum(decode(status,'OverDue',1,0)) OverDue from
2 (select b.orderno, b.status, a.orderno, a.plan from t1 a, t1 b
3 where b.parent = a.orderno)
4 group by plan;
PLAN DUE OVERDUE
-------------------- --------- ---------
p1 3 1
p2 2 2
2 rows selected.
|
|
|