--分页
SELECT * FROM
(
SELECT ROW_NUMBER() OVER(order by age desc) a,pp.* from tbl_test_01 pp
)where a between 2 and 3
--删除重复记录
delete from tbl_test_01 t1
where t1.ROWID >
(
select MIN(t2.ROWID)
from tbl_test_01 t2
where t2.name=t1.name
)
SELECT * FROM
(
SELECT ROW_NUMBER() OVER(order by age desc) a,pp.* from tbl_test_01 pp
)where a between 2 and 3
--删除重复记录
delete from tbl_test_01 t1
where t1.ROWID >
(
select MIN(t2.ROWID)
from tbl_test_01 t2
where t2.name=t1.name
)