[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] SQL Null date
- Subject: RE: [sqr-users] SQL Null date
- From: "George Jansen" <GJANSEN@aflcio.org>
- Date: Fri, 16 Sep 2005 09:39:53 -0400
- Delivery-date: Fri, 16 Sep 2005 08:41:13 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Could this be done more simply in SQL?
SELECT trunc(Nvl(date_field_1, date_field_2), 'Month) as request_month,
count(*) as request_count
FROM requests_table
GROUP BY Trunc(Nvl(date_field_2, date_field_2), 'Month')
ORDER BY request_month;
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users