连接集合
select '1' as id,'wang' as name union select '2' as id,'admin' as name
现在可以这么写了
select id,name from (values ('1','wang'), ('2','admin') ) users(id,name)
连接集合
select '1' as id,'wang' as name union select '2' as id,'admin' as name
现在可以这么写了
select id,name from (values ('1','wang'), ('2','admin') ) users(id,name)