| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> OFFTOPIC RE: sqlplus
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:prakash.bala_at_cingular.com]
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: ravindra_at_sentica.com
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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). Received on Wed Mar 28 2001 - 11:36:01 CST
 |
 |