.SELECT * FROM ( SELECT A.*, ROWNUM RN FROM( SELECT t.tname, n.title, n.author FROM t_topic t, t_news n WHERE t.id = n.tid) ) WHERE RN BETWEEN 21 AND 40;
SELECT * FROM ( SELECT A.*, ROWNUM RN FROM( SELECT t.tname, n.title, n.author FROM t_topic t, t_news n WHERE t.id = n.tid)A ) WHERE RN BETWEEN 21 AND 40;少了个A不错 还是有用的
SELECT A.*, ROWNUM RN FROM(
SELECT t.tname, n.title, n.author FROM t_topic t, t_news n
WHERE t.id = n.tid)
)
WHERE RN BETWEEN 21 AND 40;
SELECT A.*, ROWNUM RN FROM(
SELECT t.tname, n.title, n.author FROM t_topic t, t_news n
WHERE t.id = n.tid)A
)
WHERE RN BETWEEN 21 AND 40;少了个A不错 还是有用的