I have a problem about that troubles me
Posted by:
lmssee T
Date: May 13, 2023 04:39AM
if i use " select ord from dababaseName.tableName order by ord" ,i can get this result "1 2 3 4 5 6 7".
but ,when i use "select json_arrayagg(b.ord) from (select * from databaseName.tableName as a order by a.ord) as b order by d.ord" .i only get this result "[1,2,3,4,6,7,5]".
i use "order by a.ord" in this select ,but why i can't get true order .
who can save me, i have this trouble
Subject
Views
Written By
Posted
I have a problem about that troubles me
250
May 13, 2023 04:39AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.