阅读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添加一门新语言