摘要:
select * from S_dept where CODE in(select sd.code from s_dept sd start with sd.code='GDKB' connect by prior sd.code= sd.parent_code) 查找一个节点(GDKB)的所有直属 阅读全文
摘要:
1. select * from trade where id=1 and cid=1 or pid=2 ; 2. select * from trade where cid=1 or (pid=2 and id=1); 3. select * from trade where cid=1 or p 阅读全文