摘要:
1.oracle查询结果去除重复项SELECT DISTINCT * FROM TABLE_NAME2.合并查询结果select id,name from wg_personunionselect id,name from wg_superUsers从person表和superuser表中查询到的结果合并3.递归查询START WITH PID = :id CONNECT BY PRIOR ID = PID一般和union语句结合使用:START WITH PID = :id CONNECT BY PRIOR ID = PID unionselect id from wg_depart whe 阅读全文