[b]1. SQL语句分页显示[/b]
(1)oracle分页,如查询第11~20条记录
select * from (select rownum as num, m.* from member m where rownum <= 20) ta where ta.num > 10
(2)mysql查询前10条记录
select * from achievement ac limit 0,10
(1)oracle分页,如查询第11~20条记录
select * from (select rownum as num, m.* from member m where rownum <= 20) ta where ta.num > 10
(2)mysql查询前10条记录
select * from achievement ac limit 0,10