第4个回答 2010-10-20
通过
SELECT rownum AS no, * FROM 表
产生序号, 注意,这里没有任何排序,只要序号.
然后
SELECT *
FROM (SELECT rownum AS no, * FROM 表)
ORDER BY no DESC
这里根据那个 序号进行 降序排列
最后,取 降序后的前2条
SELECT
*
FROM
(
SELECT *
FROM (SELECT rownum AS no, * FROM 表)
ORDER BY no DESC
)
WHERE
rownum <= 2