Home » SQL & PL/SQL » SQL & PL/SQL » group by on date
group by on date [message #248837] Mon, 02 July 2007 05:15 Go to next message
hemu
Messages: 16
Registered: May 2007
Junior Member
thanks in advance
when i m grouping on date then problem is that it grouped it every minute also
ex
in a day it grouping three time if there is any entry in three time
in a day
Re: group by on date [message #248840 is a reply to message #248837] Mon, 02 July 2007 05:40 Go to previous messageGo to next message
ShivrajGutte
Messages: 21
Registered: April 2007
Location: PUNE
Junior Member
WHILE USING DATE IN GROUP BY CLAUSE REMOVE TIME PART FROM DATE BY USING TRUNC .
FOR E.G
SELECT EM FROM A_EMP GROUP BY EM,TRUNC(DOJ)

Regards

Re: group by on date [message #248842 is a reply to message #248840] Mon, 02 July 2007 05:51 Go to previous message
hemu
Messages: 16
Registered: May 2007
Junior Member
thank u very much.
Previous Topic: inserting values into tables
Next Topic: clob as out parameter
Goto Forum:
  


Current Time: Wed Dec 07 10:55:53 CST 2016

Total time taken to generate the page: 0.07335 seconds