sql-删除数据表中重复的数据，以保留一条

（1）根据rowid去删除

DELETE FROM q_batchreport_parent WHERE

    ROWID NOT IN (

        SELECT

            MIN(ROWID)

        FROM

            q_batchreport_parent

        WHERE

                flow_code = 'LC030'

            AND

                validflag = '1'

        GROUP BY

            batchcode

    )and flow_code='LC030'

    and validflag='1';