SELECT ROUND(K1,2)
FROM (SELECT '5.66666' UNION ALL
SELECT '5.77777' UNION ALL
SELECT '5.88888' UNION ALL
SELECT '5.99999' UNION ALL
SELECT '6.66666' UNION ALL
SELECT '7.66666' UNION ALL
SELECT '8.66666' UNION ALL
SELECT '9.66666' UNION ALL
SELECT '9.55555' UNION ALL
SELECT '6.88888' AS K1) K错误说Invalid Column name 'K1'
发布于 2017-04-17 09:47:53
union [all]结构中的列别名来自first查询,而不是最后一个查询。把你的化名移到那里,你应该会没事的:
SELECT ROUND(K1,2)
FROM (SELECT 5.66666 AS K1 UNION ALL -- Here!
SELECT 5.77777 UNION ALL
SELECT 5.88888 UNION ALL
SELECT 5.99999 UNION ALL
SELECT 6.66666 UNION ALL
SELECT 7.66666 UNION ALL
SELECT 8.66666 UNION ALL
SELECT 9.66666 UNION ALL
SELECT 9.55555 UNION ALL
SELECT 6.88888) K发布于 2017-04-17 09:47:45
为第一条记录指定列名,然后为记录取相同的rest名称。
SELECT ROUND(K1,2)
FROM (SELECT '5.66666' AS K1 UNION ALL
SELECT '5.77777' UNION ALL
SELECT '5.88888' UNION ALL
SELECT '5.99999' UNION ALL
SELECT '6.66666' UNION ALL
SELECT '7.66666' UNION ALL
SELECT '8.66666' UNION ALL
SELECT '9.66666' UNION ALL
SELECT '9.55555' UNION ALL
SELECT '6.88888') K发布于 2017-04-17 09:48:24
为第一列的第一行指定别名,或为第一列的所有行指定别名:
SELECT ROUND(K1,2)
FROM
(
SELECT '5.66666' AS K1 UNION ALL
SELECT '5.77777' AS K1 UNION ALL
SELECT '5.88888' AS K1 UNION ALL
SELECT '5.99999' AS K1 UNION ALL
SELECT '6.66666' AS K1 UNION ALL
SELECT '7.66666' AS K1 UNION ALL
SELECT '8.66666' AS K1 UNION ALL
SELECT '9.66666' AS K1 UNION ALL
SELECT '9.55555' AS K1 UNION ALL
SELECT '6.88888' AS K1
) Khttps://stackoverflow.com/questions/43449025
复制相似问题