SQL 按小时取平均值

 

select avg([Value1]) as Value1 from  THisSampleThirtySecond_1 where datediff(hour,SampleTime,'2016/10/21 0:00:00') = 0

 以此可以类推  

按小时取最大值、最小值、和；

按天、月、年、分钟、秒钟取   最大值、最小值、平均值、和   等    20170804 姜彦

posted @ 2017-08-04 15:15  <--青青子衿-->  阅读(678)  评论(0)  编辑  收藏  举报
// /**/ // 在页脚Html代码 引入 // function btn_donateClick() { var DivPopup = document.getElementById('Div_popup'); var DivMasklayer = document.getElementById('div_masklayer'); DivMasklayer.style.display = 'block'; DivPopup.style.display = 'block'; var h = Div_popup.clientHeight; with (Div_popup.style) { marginTop = -h / 2 + 'px'; } } function MasklayerClick() { var masklayer = document.getElementById('div_masklayer'); var divImg = document.getElementById("Div_popup"); masklayer.style.display = "none"; divImg.style.display = "none"; } setTimeout( function () { document.getElementById('div_masklayer').onclick = MasklayerClick; document.getElementById('btn_donate').onclick = btn_donateClick; var a_gzw = document.getElementById("guanzhuwo"); a_gzw.href = "javascript:void(0);"; $("#guanzhuwo").attr("onclick","follow('33513f9f-ba13-e011-ac81-842b2b196315');"); }, 900);