表A: TDATE,id, *
表B: id, *A和B靠id关联(A主B从),要求从A中取出100条数据按TDATE升序,并且将B中与A.id关联的所有数据取出select B.* from B where id in
(select id from A where rownum<=100 order by tdate) -- "缺失右括号"select B.* from A, B
where A.id=B.id
and A.rownum<=100 order by A.TDATE -- 不识别rownum应该怎么写啊?
表B: id, *A和B靠id关联(A主B从),要求从A中取出100条数据按TDATE升序,并且将B中与A.id关联的所有数据取出select B.* from B where id in
(select id from A where rownum<=100 order by tdate) -- "缺失右括号"select B.* from A, B
where A.id=B.id
and A.rownum<=100 order by A.TDATE -- 不识别rownum应该怎么写啊?
FROM b
WHERE id IN(
SELECT id
FROM
(SELECT id,row_number() (ORDER BY tdate) rn FROM a
)
WHERE rn <= 100
)
where b.id in
(select id from (select * from a order by TDATE) where rownum <= 100 )
select id from (
select id, rownum rn from a order by tdate
) c where rn <= 100
)