此楼,按快了。。。
那就补充
SELECT * FROM t1 WHERE id in (SELECT MIN(id) as id FROM t1 GROUP by xm,xb) INTO CURSOR tmp_t1 &&xm与xb相同的就过滤
好处是,你想认为多少个条件相同才算是重复,你就猛 group by,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
[ 本帖最后由 mywisdom88 于 2015-9-29 16:28 编辑 ]
那就补充
SELECT * FROM t1 WHERE id in (SELECT MIN(id) as id FROM t1 GROUP by xm,xb) INTO CURSOR tmp_t1 &&xm与xb相同的就过滤
好处是,你想认为多少个条件相同才算是重复,你就猛 group by,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
[ 本帖最后由 mywisdom88 于 2015-9-29 16:28 编辑 ]