{"categories":["Oracle"],"blog_title":"by shigemk2","type":"rich","width":"100%","title":"order by\u3057\u3066\u304b\u3089rownum","provider_url":"https://hatena.blog","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/shigemk2/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.shigemk2.com%2Fentry%2F2014%2F10%2F28%2Forder_by%25E3%2581%2597%25E3%2581%25A6%25E3%2581%258B%25E3%2582%2589rownum\" title=\"order by\u3057\u3066\u304b\u3089rownum - by shigemk2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_name":"shigemk2","height":"190","blog_url":"https://www.shigemk2.com/","version":"1.0","url":"https://www.shigemk2.com/entry/2014/10/28/order_by%E3%81%97%E3%81%A6%E3%81%8B%E3%82%89rownum","image_url":null,"published":"2014-10-28 13:01:56","description":"ORDER BY \u3067 ROWNUM = 1: \u3079\u3072\u3076\u308d\u3050 select * from ( select column from table order by column ) where rownum <= 10 ; select column from table where rownum <= 10 order by column; \u3063\u3066\u3084\u3063\u3066\u3082\u3046\u307e\u304f\u3044\u304b\u306a\u3044\u306e\u306f\u3001rownum\u3057\u3066\u304b\u3089order by\u3057\u3066\u3044\u308b\u304b\u3089\u3002"}