WITH t1 AS (SELECT 'data1' DATA ,SYSDATE-1 TIME FROM dual UNION ALL SELECT 'data2' DATA ,SYSDATE+1 TIME FROM dual), t2 AS (SELECT '1' num FROM dual UNION ALL SELECT '2' FROM dual)
SELECT c.DATA,c.TIME FROM ([code=SQL] SELECT row_number() over(ORDER BY a.TIME ) num,a.DATA,a.TIME FROM t1 a ) c, t2 d WHERE c.num = d.num /*+n*/ AND d.num =2
--n是t1表第一条记录对应t2表第一条记录num的对应关系(差) [/code]
WITH t1 AS (SELECT 'data1' DATA ,SYSDATE-1 TIME FROM dual UNION ALL SELECT 'data2' DATA ,SYSDATE+1 TIME FROM dual), t2 AS (SELECT '1' num FROM dual UNION ALL SELECT '2' FROM dual)
SELECT c.DATA,c.TIME FROM ( SELECT row_number() over(ORDER BY a.TIME ) num,a.DATA,a.TIME FROM t1 a ) c, t2 d WHERE c.num = d.num /*+n*/ AND d.num =2
(SELECT 'data1' DATA ,SYSDATE-1 TIME FROM dual
UNION ALL
SELECT 'data2' DATA ,SYSDATE+1 TIME FROM dual),
t2 AS
(SELECT '1' num FROM dual
UNION ALL
SELECT '2' FROM dual)
SELECT c.DATA,c.TIME FROM
([code=SQL]
SELECT row_number() over(ORDER BY a.TIME ) num,a.DATA,a.TIME
FROM t1 a
) c, t2 d
WHERE c.num = d.num /*+n*/
AND d.num =2
--n是t1表第一条记录对应t2表第一条记录num的对应关系(差)
[/code]
WITH t1 AS
(SELECT 'data1' DATA ,SYSDATE-1 TIME FROM dual
UNION ALL
SELECT 'data2' DATA ,SYSDATE+1 TIME FROM dual),
t2 AS
(SELECT '1' num FROM dual
UNION ALL
SELECT '2' FROM dual)
SELECT c.DATA,c.TIME FROM
(
SELECT row_number() over(ORDER BY a.TIME ) num,a.DATA,a.TIME
FROM t1 a
) c, t2 d
WHERE c.num = d.num /*+n*/
AND d.num =2
--n是t1表第一条记录对应t2表第一条记录num的对应关系(差)