SELECT col1, col2, count(*) FROM t1 GROUP BY col1, col2 HAVING count(*) > 1;
SELECT * FROM t1 a where a.rowid > (SELECT min(b.rowid) FROM t1 b WHERE b.col1=a.col1);
以上兩種SQL都可以。
SELECT * FROM t1 a where a.rowid > (SELECT min(b.rowid) FROM t1 b WHERE b.col1=a.col1);
以上兩種SQL都可以。
全站熱搜
留言列表
