From 0a813fba152a0bff19db334a4330a249b3539645 Mon Sep 17 00:00:00 2001
From: Junjie <540245094@qq.com>
Date: 星期四, 14 十二月 2023 20:15:39 +0800
Subject: [PATCH] #
---
src/main/resources/mapper/WrkMastLogMapper.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/src/main/resources/mapper/WrkMastLogMapper.xml b/src/main/resources/mapper/WrkMastLogMapper.xml
index 7d67a75..ae8dc76 100644
--- a/src/main/resources/mapper/WrkMastLogMapper.xml
+++ b/src/main/resources/mapper/WrkMastLogMapper.xml
@@ -67,7 +67,7 @@
</resultMap>
<select id="selectLatestByWorkNo" resultMap="BaseResultMap">
- select * from asr_wrk_mast_log wml,(select top 1 io_time,wrk_no from asr_wrk_mast_log
+ select top 1 * from asr_wrk_mast_log wml,(select top 1 io_time,wrk_no from asr_wrk_mast_log
where wrk_no = #{workNo}
group by io_time,wrk_no
order by io_time desc) a
--
Gitblit v1.9.1