Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> oracle, query, don't want sort

oracle, query, don't want sort

From: Artek Siara <artursiara_at_poczta.onet.pl>
Date: Thu, 14 Apr 2005 12:51:38 +0200
Message-ID: <d3lhvo$41q$1@galaxy.uci.agh.edu.pl>


I have that query:

SELECT * FROM (

        SELECT
            ROW_NUMBER() OVER (ORDER BY 'NAME' ASC) AS rownumber,
            ID, NAME, ADDRESS
        FROM system.tab_example

)WHERE rownumber >= 1 AND rownumber <= 3

and I don't know why a result is not sorted ? what is wrong?
thanks for help
regards, Artur Received on Thu Apr 14 2005 - 05:51:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US