CREATE TABLE TBTEST(PackCJ VARCHAR(10),Amount VARCHAR(10)) INSERT TBTEST SELECT 1 , 3 UNION ALL SELECT 2 , 2 UNION ALL SELECT 3 , 1 --SELECT * FROM TBTEST DECLARE @NUM1 INT DECLARE @NUM2 INT DECLARE @NUM3 INT SELECT @NUM1=Amount FROM TBTEST WHERE PackCJ IN (SELECT MIN(PackCJ) FROM TBTEST) SELECT @NUM2=Amount FROM TBTEST WHERE PackCJ IN (SELECT TOP 1 * FROM (SELECT TOP 2 PackCJ FROM TBTEST ORDER BY PackCJ)AS T ORDER BY PackCJ DESC) SELECT @NUM3=Amount FROM TBTEST WHERE PackCJ IN (SELECT MAX(PackCJ) FROM TBTEST)--SELECT @NUM1,@NUM2,@NUM3 SELECT CONVERT(VARCHAR(10),@NUM1*@NUM2)+':'+CONVERT(VARCHAR(10),@NUM2*@NUM3)+':'+CONVERT(VARCHAR(10),@NUM3)
INSERT TBTEST
SELECT 1 , 3 UNION ALL
SELECT 2 , 2 UNION ALL
SELECT 3 , 1 --SELECT * FROM TBTEST
DECLARE @NUM1 INT
DECLARE @NUM2 INT
DECLARE @NUM3 INT
SELECT @NUM1=Amount FROM TBTEST WHERE PackCJ IN (SELECT MIN(PackCJ) FROM TBTEST)
SELECT @NUM2=Amount FROM TBTEST WHERE PackCJ IN (SELECT TOP 1 * FROM (SELECT TOP 2 PackCJ FROM TBTEST ORDER BY PackCJ)AS T ORDER BY PackCJ DESC)
SELECT @NUM3=Amount FROM TBTEST WHERE PackCJ IN (SELECT MAX(PackCJ) FROM TBTEST)--SELECT @NUM1,@NUM2,@NUM3
SELECT CONVERT(VARCHAR(10),@NUM1*@NUM2)+':'+CONVERT(VARCHAR(10),@NUM2*@NUM3)+':'+CONVERT(VARCHAR(10),@NUM3)
--------------------------------
6:2:1(所影响的行数为 1 行)