TRUNC(posting_date, 'MON') in both select & group by should do it.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Forum Rules
Reply With Quote