请选择 进入手机版 | 继续访问电脑版
设为首页收藏本站

jeesite

 找回密码
 注册新会员
查看: 192|回复: 0

体征数据

[复制链接]
admin 发表于 2018-7-12 00:51:58 | 显示全部楼层 |阅读模式
  1. SELECT  
  2. AVG(a.systolic_pressure) AS avgSystolicPressure,
  3. AVG(a.heart_rate) AS avgHeartRate ,
  4. AVG(a.blood_sugar) AS avgBloodSugar ,
  5. AVG(a.weight) AS avgWeight,  
  6. AVG(a.urine_output)  AS avgUrineOutput,

  7. MAX(a.systolic_pressure) AS maxSystolicPressure,
  8. MAX(a.heart_rate) AS maxHeartRate,
  9. MAX(a.blood_sugar) AS maxBloodSugar,
  10. MAX(a.weight) AS maxWeight,  
  11. MAX(a.urine_output)  AS maxUrineOutput,

  12. MIN(a.systolic_pressure) AS minSystolicPressure,
  13. MIN(a.heart_rate) AS minHeartRate,
  14. MIN(a.blood_sugar) AS minBloodSugar,
  15. MIN(a.weight) AS minWeight,  
  16. MIN(a.urine_output)  AS maxUrineOutput

  17. FROM maida_body_data a        WHERE a.del_flag = '0'
复制代码
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册新会员

本版积分规则

QQ|手机版|小黑屋|Archiver|jeesite 官方论坛. ( 吉ICP备12004769号  

GMT+8, 2018-11-17 10:56 , Processed in 0.146484 second(s), 22 queries .

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表