Code34从两个表中找出最大值

来源:互联网 发布:爱知重庆 编辑:程序博客网 时间:2024/04/29 11:52

SELECT TOP 1 sal

FROM (SELECT MAX(sal) AS sal

FROM sal1

UNION

SELECT MAX(sal) AS sal

FROM sal2) a

ORDER BY sal DESC