SELECT Right(T0.[CardCode], 3) As Number, T0.[CardCode], T0.[CardName]
FROM OCRD T0 WHERE T0.[CardType] ='C'
ORDER BY Right(T0.[CardCode], 3) DESC
查询出客户编号按最后三个数字由大到小排序的记录(我的第一个SAP B1 Query)
最新推荐文章于 2023-02-23 10:01:21 发布
SELECT Right(T0.[CardCode], 3) As Number, T0.[CardCode], T0.[CardName]
FROM OCRD T0 WHERE T0.[CardType] ='C'
ORDER BY Right(T0.[CardCode], 3) DESC