OrderBy/GroupBy

I made a group by using Date and a category. Scriptcase automatically adds an order by at the end of my sql query such as Order by year(date) desc, month(date) desc, day(date), Category(desc). I do not want to also order by the day(date). Is there a way to edit this order by statement or turn off an automatic order by statement created by scriptcase when I use a group by? Any help would be appreciated