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

Options: ReplyQuote


Subject
Views
Written By
Posted
I have a problem about that troubles me
135
May 13, 2023 04:39AM


Sorry, only registered users may post in this forum.

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.