This post would have been ALOT funnier, if Ravindra's
name was, instead, "Ganesh".
(Sorry about all you folks that don't like Hindu Mythology based
puns.)
-----Original Message-----
From: Bala, Prakash [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: sqlplus
Ravindra, try using 'trunc' on your group by clause.
-----Original Message-----
Sent: Wednesday, March 14, 2001 7:11 PM
To: Multiple recipients of list ORACLE-L
Can we use the group by clause on a date column.I am written a query to get
a count(*) of records with a group by clause on the date column and with
date
b/w two specified dates.but the query just keep executing w/o giving any
o/p
or errors.The date field will also have the timestamp.Will this be a
problem.
I also tried with using the to_char but no success.
How do i get the o/p.
EX:The requirement is like say in a table with phone call info we want to
display the count of call made b/w two dates in a month and grouped by
date.
Thanks
Ravindra
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ravindra Basavaraja
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bala, Prakash
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
