goInception
goInception copied to clipboard
创建视图包含以下语句报错Column 'num' in field list is ambiguous.
描述
对问题简单清晰的描述
创建视图包含以下语句报错
(
select
*
from
test
where
id in (
SELECT
max(id)
FROM
test
where
num is not null
group by
num
)
)