mysql语句总结2
来源:互联网 发布:供应商数据分析 编辑:程序博客网 时间:2024/06/01 19:46
默认查询4个小时内的数据,还可以根据输入的时间段进行查询出时间最大的那条数据
<select id="queryPositionMechaincsInfo" parameterType="pd" resultType="pd"> SELECT s.bs_id,s.bs_name,s.positionX,s.positionY,m.equ_state_id,m.equ_id,m.equ_name,m.equ_num,l.lab_num,lv.judge_res,r.rfid_ip,lv.trigger_date FROM sys_mechanics_info AS m LEFT JOIN t_aps_label_info AS l ON l.user_id = m.equ_id LEFT JOIN t_aps_labelrecordview AS lv ON lv.label_num = l.lab_num LEFT JOIN t_aps_reader as r ON r.rfid_ip = lv.rfid_ip LEFT JOIN t_aps_base_station AS s ON r.pass_id = s.bs_id LEFT JOIN sys_mechanics_state AS ms ON ms.sta_id = m.equ_state_id <where> <choose> <when test=" null!=start_date and start_date !='' or null!=end_date and end_date !='' "> <!--根据输入的时间段来查询数据 --> <![CDATA[lv.trigger_date>=#{start_date} and lv.trigger_date<=#{end_date}]]> </when> <when test=" null!=equ_state_id and equ_state_id !='' or null!=equ_id and equ_id !=''"> <!--当输入的时间段为空时,执行下面语句:及选出时间最大的那条数据 --> AND lv.trigger_date=(SELECT MAX(lv.trigger_date) FROM sys_mechanics_info AS m LEFT JOIN t_aps_label_info AS l ON l.user_id = m.equ_id LEFT JOIN t_aps_labelrecordview AS lv ON lv.label_num = l.lab_num LEFT JOIN t_aps_reader as r ON r.rfid_ip = lv.rfid_ip LEFT JOIN t_aps_base_station AS s ON r.pass_id = s.bs_id LEFT JOIN sys_mechanics_state AS ms ON ms.sta_id = m.equ_state_id WHERE 1=1 <if test="null!=equ_id and equ_id !=''"> and m.equ_id=#{equ_id} </if> <if test="null!=equ_state_id and equ_state_id !=''"> AND m.equ_state_id=#{equ_state_id} </if> ) </when> <otherwise> <!-- 当输入的时间段为空时,默认查询4个小时内的那个时间最大的那条数据 --> <![CDATA[lv.trigger_date >DATE_SUB(NOW(),INTERVAL 4 HOUR) AND lv.trigger_date< NOW()]]> </otherwise> </choose> AND lv.judge_res=2 </where> ORDER BY lv.trigger_date DESC</select>
阅读全文
0 0
- MySQL语句总结2
- Mysql语句总结(2)
- mysql语句总结2
- MySQL语句总结
- MySQL语句总结
- MySql Sql语句总结
- mysql语句总结
- 常用mysql语句总结
- mysql语句总结
- mysql常用语句总结
- 【总结】MySQL 语句
- mysql常用语句总结
- MySQL语句总结
- MySql语句总结
- MySQL基本语句总结
- mysql sql语句总结
- mysql语句总结
- MySql查询语句总结
- Xilinx Petalinux 开发环境搭建与安装
- Proto-Gen-Lua 环境搭建编译、安装、使用
- SOLIDWORKS PDM 2017 客户端激活问题
- STM32 串口发送配置流程
- xgboost参数详解
- mysql语句总结2
- 九种基本数据类型的大小,以及他们的封装类。
- Codeforces 839D Winter is here 组合数公式/容斥
- 学习SpringMVC——跟我学SpringMVC目录汇总贴、PDF下载、源码下载
- task20任务总结
- Qt QStringList的简单使用方法
- macOS Windows 和 WindowController 教程
- java操作时间,将当前时间减一年,减一天,减一个月
- CF 453A(Little Pony and Expected Maximum-若干次掷骰,最大那次期望-推公式)