what about
create view myview(myear, mmonth, mday) as
select f_year(ts) myear, f_month(ts) mmonth, f_dayormonth(ts) mday from
table1;

then
select myear, mmonth, mday count(*) from myview group by myear, mmonth, mday
having count()* >0


-----Original Message-----
From: tickerboo2002 [mailto:support@...]
Sent: Monday, 16 September 2002 22:05
To: ib-support@yahoogroups.com
Subject: [ib-support] SQL: Number of entries per day


Hello

I have a table defined as:

ID integer
ts timestamp
desc varchar(100)

Is it possible with one query to retrieve the number of entries per
day? I assume you would need to cast the timestamp to an integer(?)
and then do some sort of group by.

Ideally, I need the results in the following format:

timestamp, count of entries that day.


preferably with no row returned for days with no entries.

TIA

David



Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]