Hi everyone,
I'm creating a custom scrip in which I need to execute a query with the order by clause. I specified it in the where caluse but there is a default "order by cn" in the final query. Here you can see the two queries.
Where clasue: "UID_UNSGroupB in (select top 27 UID_UNSGroupB from UNSGroupB where UID_UNSContainerB = 'c4f3feb6-9dde-4768-9545-1d0f7c313321' order by ObjectGUID)"
Query executed in the database with my where clause: "select UID_UNSGroupB, cn, CanonicalName, xmarkedfordeletion from UNSGroupB where ((UID_UNSGroupB in (select top 27 UID_UNSGroupB from UNSGroupB where UID_UNSContainerB = 'c4f3feb6-9dde-4768-9545-1d0f7c313321' order by ObjectGUID))) order by cn"
Is there a way to avoid the "order by cn" at the end?
Thank you
Simone