You need to sign in to do that
Don't have an account?
Order By help... Should be an easy one (Ihope)
I have the following query, but I need to order the results by ActivityDate in descending order.
SELECT (SELECT
ActivityDate,
Description,
Subject,
IsClosed,
CallType,
CallDisposition,
Status,
ActivityType
FROM OpenActivities
)
FROM Account
if I put order by ActivityDate desc like so:
SELECT (SELECT
ActivityDate,
Description,
Subject,
IsClosed,
CallType,
CallDisposition,
Status,
ActivityType
FROM OpenActivities
order by AcivityDate desc
)
FROM Account
It comes out the same order as if I don't have any order by. Can anyone tell me how to get the order in the way I need it?
Thanks so much.
The order by key word is used correctly in this example, how are you processing these records for display after the query? Because that may be where the issue occurs.