求助:Oracle分页的小问题
问大家一个oracle数据库分页的问题:
假设有个table CLIENTS :
NAME, PASSWORD, LAST_LOGIN_DATE
a1 b 2006-9-1
a2 b 2005-8-1
a3 b 2004-4-11
a4 b 2002-12-11
a5 b 2006-9-18
a6 b 2006-9-21
a7 b 2006-9-24
a8 b 2006-9-27
a9 b 2006-9-12
a10 b 2006-9-13
..............................
在写SQL的时候,我写了两条不同的语句:
select * from (select c.*,rownum r from CLIENTS c) where r between 2 and 8 and LAST_LOGIN_DATE between to_date('2006-8-1','yy-mm-dd')
and to_date('2006-9-30','yy-mm-dd')
和
select * from (select c.*,rownum r from CLIENTS c where LAST_LOGIN_DATE between to_date('2006-8-1','yy-mm-dd')
and to_date('2006-9-30','yy-mm-dd')) where r between 2 and 8
自我感觉两次的结果集应该是一样的,但执行SQL后发现并非如此,不知为何
望大家给个详细的解释,并告知哪条语句是正确的,辛苦大家啦