不好意思,沒看清題意
以下隻是一種方法,可以要根據你的實際情況改點數字!
[php]
SQL> select * from tt;
ID NO COLNAME
---------- ---------- ----------
1
bill_1 sales
2
bill_1 pur
3
bill_1 mov
4
bill_2 sales
5
bill_2 pur
6
bill_3 sales
7
bill_3 mov
已選取 7 個資料列.
目前歷時: 00:00:00.00
SQL> select * from (select tt.*,sum(decode(colname,'sales',1,'pur',100000,2)) over(partition by no) cnt from tt) where cnt = 100001;
ID NO COLNAME CNT
---------- ---------- ---------- ----------
4
bill_2 sales
100001
5
bill_2 pur
100001
目前歷時: 00:00:00.00
SQL>
SQL> select * from (select tt.*,sum(decode(colname,'sales',1,'pur',0.13,2)) over(partition by no) cnt from tt) where cnt = 1.13;
ID NO COLNAME CNT
---------- ---------- ---------- ----------
4
bill_2 sales
1.13
5
bill_2 pur
1.13
目前歷時: 00:00:00.00
SQL>
----
[/php] |