14:54:20 jlanzpa817>desc groupby;
名称 空? 类型
----------------------------------------- -------- ----------------------------
A NUMBER
B NUMBER
C NUMBER
14:54:29 jlanzpa817>select * from groupby;
1 1 1
1 1 2
1 2 1
1 2 2
1 3 1
1 3 2
已用时间: 00: 00: 00.30
14:54:32 jlanzpa817>select * from groupby where rowid in (select a.rid from
14:54:34 2 ( select a,b,min(rowid) rid from groupby group by a,b ) a );
1 1 1
1 2 1
1 3 1
已用时间: 00: 00: 00.11
名称 空? 类型
----------------------------------------- -------- ----------------------------
A NUMBER
B NUMBER
C NUMBER
14:54:29 jlanzpa817>select * from groupby;
1 1 1
1 1 2
1 2 1
1 2 2
1 3 1
1 3 2
已用时间: 00: 00: 00.30
14:54:32 jlanzpa817>select * from groupby where rowid in (select a.rid from
14:54:34 2 ( select a,b,min(rowid) rid from groupby group by a,b ) a );
1 1 1
1 2 1
1 3 1
已用时间: 00: 00: 00.11