閱讀102 返回首頁    go 阿裏雲 go 技術社區[雲棲]

查詢3月的血壓值得SQL語句

SELECT DATE_FORMAT(monitor_time, '%Y-%m-%d'),  avg(blood_systolic) FROM health_cloud_new.t_neowave_blood_pressure 
where family_id = 1 and family_no = 1
 and monitor_time>='2013-05-01 00:00:00' and monitor_time<= '2013-06-01 24:00:00' group by 1 
order by 1 desc;

最後更新：2017-04-03 16:48:31

  上一篇：go ANDROID fastboot刷機傻瓜教程
  下一篇：go 為Android添加一門新語言