Error in command
HI,
I have used this command in a program for a few years:
"SELECT DISTINCT DATE_FORMAT(PeriodStart, '%Y') as Year FROM LedgerPeriod ORDER BY PeriodStart DESC"
However after a server upgrade yesterday this command does not longer work.
I have to remove the ORDER BY, then it works.
But this is not what I want. I need to have a order by in there somehow. How can I fix this?
Subject
Written By
Posted
Error in command
April 01, 2019 07:02AM
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.