createtable t(col1 int,col2 int,col3 int) ---- 创建一个测试表 go insert t ---插入记录 select1,2,3unionall select0,2,9unionall select8,4,7unionall select7,1,15 go select*---查询表记录 from t go --------------查询显示----------------------- col1 col2 col3 minvalue maxvalue 12313 02909 84748 7115115 -------------------------------------------- select*, minvalue=(selectmin(b.v) from (select v=a.col1 unionallselect v=a.col2 unionallselect v=a.col3) b), maxvalue=(selectmax(b.v) from (select v=a.col1 unionallselect v=a.col2 unionallselect v=a.col3) b) from t a