CREATE TABLE tb (val int) INSERT INTO tb SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 5SELECT t1.val AS [最大值] FROM tb AS t1 WHERE NOT EXISTS(SELECT * FROM tb AS t2 WHERE t2.val>t1.val) SELECT t1.val AS [最小值] FROM tb AS t1 WHERE NOT EXISTS(SELECT * FROM tb AS t2 WHERE t2.val<t1.val) DROP TABLE tb--执行结果-- 最大值 ----------- 5(1 行受影响)最小值 ----------- 1(1 行受影响)
CREATE TABLE tb (val int)
INSERT INTO tb
SELECT 1 UNION ALL
SELECT 2 UNION ALL
SELECT 3 UNION ALL
SELECT 5SELECT t1.val AS [最大值] FROM tb AS t1 WHERE NOT EXISTS(SELECT * FROM tb AS t2 WHERE t2.val>t1.val)
SELECT t1.val AS [最小值] FROM tb AS t1 WHERE NOT EXISTS(SELECT * FROM tb AS t2 WHERE t2.val<t1.val)
DROP TABLE tb--执行结果--
最大值
-----------
5(1 行受影响)最小值
-----------
1(1 行受影响)