create
table
t(col1
int
,col2
int
,col3
int
)
--
-- 创建一个测试表
go
insert t -- -插入记录
select 1 , 2 , 3 union all
select 0 , 2 , 9 union all
select 8 , 4 , 7 union all
select 7 , 1 , 15
go
select * -- -查询表记录
from t
go
-- ------------查询显示-----------------------
col1 col2 col3 minvalue maxvalue
1 2 3 1 3
0 2 9 0 9
8 4 7 4 8
7 1 15 1 15
-- ------------------------------------------
select * , minvalue = ( select min (b.v) from ( select v = a.col1 union all select v = a.col2 union all select v = a.col3) b),
maxvalue = ( select max (b.v) from ( select v = a.col1 union all select v = a.col2 union all select v = a.col3) b)
from t a
go
insert t -- -插入记录
select 1 , 2 , 3 union all
select 0 , 2 , 9 union all
select 8 , 4 , 7 union all
select 7 , 1 , 15
go
select * -- -查询表记录
from t
go
-- ------------查询显示-----------------------
col1 col2 col3 minvalue maxvalue
1 2 3 1 3
0 2 9 0 9
8 4 7 4 8
7 1 15 1 15
-- ------------------------------------------
select * , minvalue = ( select min (b.v) from ( select v = a.col1 union all select v = a.col2 union all select v = a.col3) b),
maxvalue = ( select max (b.v) from ( select v = a.col1 union all select v = a.col2 union all select v = a.col3) b)
from t a