本帖最后由 jimn1982 于 2013-6-20 14:13 编辑
有这样一个表:
create table X
(
PDATE DATE,
PID NUMBER
);
insert into x (PDATE, PID)
values (to_date('11-06-2013', 'dd-mm-yyyy'), '1');
insert into x (PDATE, PID)
values (to_date('11-06-2013', 'dd-mm-yyyy'), '2');
insert into x (PDATE, PID)
values (to_date('11-06-2013', 'dd-mm-yyyy'), '3');
insert into x (PDATE, PID)
values (to_date('11-06-2013', 'dd-mm-yyyy'), '4');
insert into x (PDATE, PID)
values (to_date('12-06-2013', 'dd-mm-yyyy'), '1');
insert into x (PDATE, PID)
values (to_date('12-06-2013', 'dd-mm-yyyy'), '2');
insert into x (PDATE, PID)
values (to_date('12-06-2013', 'dd-mm-yyyy'), '3');
insert into x (PDATE, PID)
values (to_date('12-06-2013', 'dd-mm-yyyy'), '4');
commit;
PDATE
PID
----------- ----------
2013-6-11
1
2013-6-11
2
2013-6-11
3
2013-6-11
4
2013-6-12
1
2013-6-12
2
2013-6-12
3
2013-6-12
4
什么方法最好查询一个范围从pdate=2013-6-11和pid=4开始
到pdate=2013-6-12和pid=3为止的这几条记录
|