如何从表中获取最大值 [英] How to get max value from table

问题描述

我从表中得到的最大值是20

但是我想把它显示为4位数的0020



谢谢

I had get max value from table is 20
but i want show it like 0020 in 4 digit

Thanks

推荐答案

select STUFF(MAX(wo_closed), 1, 0, REPLICATE('0', 4 - LEN(MAX(wo_closed)))) as wo_closed from inventory 

修改使用hypermellow提供的示例

查看 STUFF 功能，那么你可以这样做吗？

Have a look at the STUFF function, then you could do something like this?

SELECT STUFF(MAX(ID), 1, 0, REPLICATE('0', 4 - LEN(MAX(ID)))) FROM YourTable;

你是T吗？正确的功能.....？它非常简单....查看下面的查询

Hi,

Are you Tried RIGHT Function.....? Its very simple.... check the below Query

-- Direct from Table 
DECLARE @Test TABLE (ID INT)

INSERT INTO @Test(ID)
SELECT 10 UNION ALL SELECT 16 UNION ALL
SELECT 20 UNION ALL SELECT 15 UNION ALL
SELECT 5 UNION ALL SELECT 7

SELECT MAX(ID) , RIGHT('0000'+CAST(MAX(ID)AS VARCHAR(10)),4)
FROM @Test

-- Using Variables
DECLARE @MaxValue INT
SELECT @MaxValue=20
SELECT @MaxValue, RIGHT('0000'+CAST(@MaxValue AS VARCHAR(10)),4)

问候，

GVPrabu

Regards,
GVPrabu

这篇关于如何从表中获取最大值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！