Account | |
Acct_No | Type |
10001 | Savings |
10002 | Savings |
10003 | Savings |
10004 | Savings |
10005 | Savings |
10002 | Savings |
10002 | Savings |
10005 | Savings |
60001 | Checking |
60002 | Checking |
|
|
select * from Account b where a.acct_no = b.acct_no and a.RowID > b.RowID
);
子查询的功能是找出重复的列。