mysql单号内排序

最新推荐文章于 2023-03-31 11:49:59 发布

yangpjit

最新推荐文章于 2023-03-31 11:49:59 发布

阅读量222

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.csdn.net/yangpit/article/details/102784617

CREATE DEFINER=aaa@% FUNCTION kenzo_get_sales_line(_order_sn varchar(60),_line_no INT) RETURNS int(11)
BEGIN

DECLARE _return INT;
SET _return =(
select A.order_num from (
SELECT trans_num,line_position,@rownum := @rownum +1 AS order_num
FROM kenzo_sd_sales_detail_out, (SELECT@rownum :=0) r
WHERE trans_num =_order_sn
order by line_position) as A where A.line_position=_line_no);

RETURN _return;

END