从Oracle中的表中选择第N行 [英] Select Nth Row From A Table In Oracle

问题描述

如何从Oracle的表中选择第N行?

How can I select the Nth row from a table in Oracle?

我尝试过

SELECT PRICE FROM AAA_PRICING WHERE ROWNUM = 2

但是没有用.请帮忙！

推荐答案

基于经典答案:

http://asktom .oracle.com/pls/asktom/f?p = 100:11:0 ::::: P11_QUESTION_ID:127412348064

select * 
  from ( select a.*, rownum rnum
           from ( YOUR_QUERY_GOES_HERE -- including the order by ) a
          where rownum <= N_ROWS )
 where rnum >= N_ROWS
/

这篇关于从Oracle中的表中选择第N行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！