oracle - 选择最后 12 行 oracle

Question

我想在 oracle 中做一个返回或多或少 300 行的选择，但我只想要最后 12 个注册表。这是查询:

(SELECT * 
FROM series 
ORDER BY odata DESC) estatisticas 
WHERE ponteiro = 50 AND lotus = 30

Answer 1

类似的东西:

select * from 
    ( select estatisticas, rownum rn
        (SELECT *
        FROM series 
        ORDER BY odata DESC) estatisticas 
        WHERE ponteiro = 50 AND lotus = 30
    order by odata asc) where rownum <=12

编辑:
为您的查询更新了它，您希望将其与内部查询相反排序，在您的情况下升序，因此您可以获得最后 12 个