单个字段:
select distinct(a) from tableA;
多个字段,利用max()去重
SELECT
*
FROM
pon_order_td_process_log g
WHERE
g.ROWID = ( SELECT max( s.ROWID ) FROM pon_order_td_process_log s WHERE g.DRAFTID = s.DRAFTID );
单个字段:
select distinct(a) from tableA;
多个字段,利用max()去重
SELECT
*
FROM
pon_order_td_process_log g
WHERE
g.ROWID = ( SELECT max( s.ROWID ) FROM pon_order_td_process_log s WHERE g.DRAFTID = s.DRAFTID );