select b, c from(select b,c, rownum as id from aaa order by b,c) where id != 1;
select b, c from(select b,c from aaa order by b,c) where rownum<= 1;
查询第一条 select b, c from(select b,c, rownum as id from aaa order by b,c) where id = 1; 删除 除了第一条的 delete from aaa where rowid not in (select rowid from (select b,c, rownum as id from aaa order by b,c) where id = 1);
同意 airson 79 select b, c from(select b,c from aaa order by b,c) where rownum <= 1;先排序再對其查詢
select b, c from(select b,c, rownum as id from aaa order by b,c) where id = 1;
删除 除了第一条的
delete from aaa
where rowid not in (select rowid from (select b,c, rownum as id from aaa order by b,c) where id = 1);
select b, c from(select b,c from aaa order by b,c) where rownum <= 1;先排序再對其查詢