首页 \ 问答 \ Sql查询查找过去值的平均值(Sql query to find averages of past values)

Sql查询查找过去值的平均值(Sql query to find averages of past values)

 我有一些数据可以在一天中以正常的小时间隔记录一个值（卷）到oracle sql数据库。 我正在寻找一个sql查询，可以找到过去发生的平均量，所以我可以根据过去的时间将其插入到新表中。 例如，对于每个星期三晚上7点，只要我的数据集返回，我想找到当时所有星期三晚上7点的平均值，并将平均值输出到新记录。 然后找到星期三晚上8点，然后是晚上9点等的平均录音，直到一周的所有7天都完成。  
 我主要不确定如何在sql中增加它。 我想我的查询会返回我想要的内容，但我不确定如何增加值并插入。  
 到目前为止，我在特定日期的特定时段内有这个：  
SELECT hour,day,AVG(volume)
FROM table
WHERE to_char(day, 'D') = 3 and hour = 19
GROUP BY hour,day;

I have some data that logs a value (volume) in regular hourly intervals throughout the day to an oracle sql database. I am looking for an sql query that can find the average volume from occurrences in the past so I can insert that into a new table based on that time in the past. For example, for every Wednesday at 7pm for as long as my dataset goes back, I want to find what the average was at that time for all Wednesdays at 7pm in the past, and output the average to a new record. Then find the average recording for Wednesdays at 8pm , then 9pm and so forth, until all 7 days in a week are complete. 
I am primarily unsure of how to increment this in sql. I think I have a query that will return what I want, but I am unsure of how to increment the values and insert. 
So far I have this for a particular hour of a particular day: 
SELECT hour,day,AVG(volume)
FROM table
WHERE to_char(day, 'D') = 3 and hour = 19
GROUP BY hour,day;

原文：https://stackoverflow.com/questions/16756969

更新时间：2023-01-09 11:01

最满意答案

 这可以通过设置来解决......  
grails.mime.file.extensions = false
 
 ...在Config.groovy中。  
 似乎Grails试图根据文件名后缀在场景后面做一些MIME魔术。  
 更新： Grails JIRA的一些其他信息。  
 这是UrlMappingsFilter.java中的违规代码：  
    if(WebUtils.areFileExtensionsEnabled()) {
        String format = WebUtils.getFormatFromURI(uri);
        if(format!=null) {
            MimeType[] configuredMimes = MimeType.getConfiguredMimeTypes();
            // only remove the file extension if its one of the configured mimes in Config.groovy                                                                                                           
            for (MimeType configuredMime : configuredMimes) {
                if (configuredMime.getExtension().equals(format)) {
                    request.setAttribute(GrailsApplicationAttributes.CONTENT_FORMAT, format);
                    uri = uri.substring(0, (uri.length() - format.length() - 1));
                    break;
                }
            }
        }
    }
 
 WebUtils.areFileExtensionsEnabled（）返回Config.groovy中配置的“grails.mime.file.extensions”设置的值。 

This can be solved by setting ... 
grails.mime.file.extensions = false
 
... in Config.groovy. 
It seems like Grails is trying to do some MIME magic behind the scene based on the file name suffix. 
Updated: Some additional info from the Grails JIRA. 
This is the offending code in UrlMappingsFilter.java: 
    if(WebUtils.areFileExtensionsEnabled()) {
        String format = WebUtils.getFormatFromURI(uri);
        if(format!=null) {
            MimeType[] configuredMimes = MimeType.getConfiguredMimeTypes();
            // only remove the file extension if its one of the configured mimes in Config.groovy                                                                                                           
            for (MimeType configuredMime : configuredMimes) {
                if (configuredMime.getExtension().equals(format)) {
                    request.setAttribute(GrailsApplicationAttributes.CONTENT_FORMAT, format);
                    uri = uri.substring(0, (uri.length() - format.length() - 1));
                    break;
                }
            }
        }
    }
 
WebUtils.areFileExtensionsEnabled() returns the value of the "grails.mime.file.extensions" setting configured in Config.groovy.

Sql查询查找过去值的平均值(Sql query to find averages of past values)

最满意答案

相关问答

Grails UrlMappings，参数值包含“。”(Grails UrlMappings with parameter values containing “.”)[2024-02-15]

如何在UrlMappings.groovy中重写Grails中的URI(How to rewrite a URI in Grails within UrlMappings.groovy)[2022-02-26]

grails urlMappings dsl(grails urlMappings dsl)[2021-05-15]

Grails URLMappings使用错误的URL(Grails URLMappings uses the wrong URL)[2023-08-12]

使用.html Grails UrlMappings(Grails UrlMappings with .html)[2022-04-01]

使用Grails，我可以在UrlMappings.groovy中指定控制器，操作和视图吗？(With grails, can I specify the controller, action, and view in UrlMappings.groovy?)[2024-02-06]

urlmappings更改 - grails 2到3升级(urlmappings changes - grails 2 to 3 upgrade)[2022-03-09]

Grails - 只获取URL参数(Grails - Only get URL params)[2022-04-02]

Grails urlMappings动作和控制器行为不使用控制器逻辑(Grails urlMappings action and controller behavior not using controller logic)[2022-07-31]

Grails i18n UrlMappings(Grails i18n UrlMappings)[2021-10-05]

相关文章

最新问答