BIRT SQL Query
- staleyda
- Posts:1
- Joined: Thu Aug 11, 2016 11:44 pm
BIRT SQL Query
I need help with a SQL query for a report. I'm archiving data in one minute increments. I would like to poll the value for a report but I want to see the value from every 10 minutes. I would also like to query the last record of the day. Can I structure the query to support that?
- Gertjan van Schijndel
- Posts:634
- Joined: Mon Aug 02, 2010 10:37 am
Re: BIRT SQL Query
The value from every 10 minutes -> GROUP BY SECS(600)
The last record of the day -> LAST
More information regarding these SQL keywords can be found in the online help under: System management -> Reporting -> SQL -> SQL keywords
The last record of the day -> LAST
More information regarding these SQL keywords can be found in the online help under: System management -> Reporting -> SQL -> SQL keywords