From 04d78630d14c6509c4b1711ec03412baddef43a0 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期四, 01 四月 2021 15:38:32 +0800
Subject: [PATCH] #
---
src/main/resources/mapper/PriorMapper.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/src/main/resources/mapper/PriorMapper.xml b/src/main/resources/mapper/PriorMapper.xml
index 1a8958b..23194bf 100644
--- a/src/main/resources/mapper/PriorMapper.xml
+++ b/src/main/resources/mapper/PriorMapper.xml
@@ -38,7 +38,7 @@
select * from
(
select
- ROW_NUMBER() over (order by mp.create_time desc) as row,
+ ROW_NUMBER() over (order by isnull(round((ls.amount/mp.safe_qua),2),0) asc) as row,
mp.node_id,
mp.node_name,
mp.matnr,
--
Gitblit v1.9.1