去掉两个表中相同的记录,留下第一个表中不同的记录;如下例子:
select rownum,t.* from tfundinfo t where c_fundcode in ('501001','502001','171001');
select rownum,t.* from tfundinfo t where c_fundcode in ('501001','502001','172001','551001');
select rownum,t.* from tfundinfo t where c_fundcode in ('501001','502001','171001')
minus select rownum,t.* from tfundinfo t where c_fundcode in ('501001','502001','172001','551001');