表结构及内容如下：
ID PID DID KEY VALUE
425 applygoods.180001 90001 sys_tel 139988*****
426 applygoods.180001 90001 sys_name 1000800168
427 applygoods.180001 90001 htm_sl 32
428 applygoods.180001 90001 sys_dept 0102360601
429 applygoods.180001 90001 bpm_sqlb 1
430 applygoods.180001 90001 owner 1000800168
431 applygoods.180001 90001 bpm_wplb 3
432 applygoods.180001 90001 htm_xh xcvsdfsdf
433 applygoods.180001 90001 bpm_jfly 7
434 applygoods.180001 90001 opinion 同意
435 applygoods.180001 90001 htm_textarea xvcsdf
358 applygoods.150005 90001 htm_bz zxvcb eraw xcva swfewrgbcdezcvbbnfd
359 applygoods.150005 90001 sys_tel 139988*****
360 applygoods.150005 90001 htm_sl 5
361 applygoods.150005 90001 sys_name 1000800168
362 applygoods.150005 90001 bpm_sqlb 1
363 applygoods.150005 90001 bpm_wplb 4
364 applygoods.150005 90001 bpm_jfly 7
365 applygoods.150005 90001 htm_xh cvb23xcvsdfazvcbxcbzxcv
366 applygoods.150005 90001 htm_textarea xcvas324
367 applygoods.150005 90001 sys_dept 0102360601
368 applygoods.150005 90001 owner 1000800168
369 applygoods.150005 90001 opinion 不同意
425 applygoods.200002 90005 sys_tel 139988*****
426 applygoods.200002 90005 sys_name 1000800168
427 applygoods.200002 90005 htm_sl 32
428 applygoods.200002 90005 sys_dept 0102360601
429 applygoods.200002 90005 bpm_sqlb 1
430 applygoods.200002 90005 owner 1000800168
431 applygoods.200002 90005 bpm_wplb 3
432 applygoods.200002 90005 htm_xh xcvsdfsdf
433 applygoods.200002 90005 bpm_jfly 7
434 applygoods.200002 90005 opinion 同意
435 applygoods.200002 90005 htm_textarea xvcsdf
查询的需求是pid和did相同的记录为一组，按key里的value值查询满足条件的pid和did。例如查询条件为bpm_sqlb=1,bpm_wplb=3和bpm_jfly=7，查询pid和did的结果为applygoods.180001,90001和applygoods.200002,90005两条记录
恳请各位帮忙看看有没有什么好的思路，先谢谢了
附建表语句及数据
- SQL code
create table TEST( ID VARCHAR2(255 CHAR) not null, PID VARCHAR2(255 CHAR), DID VARCHAR2(255 CHAR), KEY VARCHAR2(255 CHAR), VALUE VARCHAR2(2000 CHAR))
- SQL code
insert into test (ID, PID, DID, KEY, VALUE)
values ('425', 'applygoods.180001', '90001', 'sys_tel', '139988*****');
insert into test (ID, PID, DID, KEY, VALUE)
values ('426', 'applygoods.180001', '90001', 'sys_name', '1000800168');
insert into test (ID, PID, DID, KEY, VALUE)
values ('427', 'applygoods.180001', '90001', 'htm_sl', '32');
insert into test (ID, PID, DID, KEY, VALUE)
values ('428', 'applygoods.180001', '90001', 'sys_dept', '0102360601');
insert into test (ID, PID, DID, KEY, VALUE)
values ('429', 'applygoods.180001', '90001', 'bpm_sqlb', '1');
insert into test (ID, PID, DID, KEY, VALUE)
values ('430', 'applygoods.180001', '90001', 'owner', '1000800168');
insert into test (ID, PID, DID, KEY, VALUE)
values ('431', 'applygoods.180001', '90001', 'bpm_wplb', '3');
insert into test (ID, PID, DID, KEY, VALUE)
values ('432', 'applygoods.180001', '90001', 'htm_xh', 'xcvsdfsdf');