摘要：
Oracle中：distinct会影响rownum的约束条件。可能是先rownum, 然后再distinct的。select manager_id,manager_name from ( SELECT a.manager_id, a.manager_name, (sysdate-perf_score.max_perf_track_rec (c.track_record_id,'Q'))... 阅读全文
posted @ 2007-07-11 11:46 Snapping 阅读(1548) 评论(0) 推荐(0) 编辑