Subject | Extract Function |
---|---|
Author | Ajay |
Post date | 2002-11-14T14:08:32Z |
hi
I am using an extract function with Group By Clause.But the Results are very different. For example my Query is
Select Count(ID), Extract (Day from Msg_Date)
From DR_Main
Group By Msg_Date ( I tried using Group By (Day From Msg_Date) but if failed so i tried using Only Msg_Date)
Ajay.
[Non-text portions of this message have been removed]
I am using an extract function with Group By Clause.But the Results are very different. For example my Query is
Select Count(ID), Extract (Day from Msg_Date)
From DR_Main
Group By Msg_Date ( I tried using Group By (Day From Msg_Date) but if failed so i tried using Only Msg_Date)
Ajay.
[Non-text portions of this message have been removed]