如果我想把
select b.itemid
from user a
left join agency b on a.test = b.code
where length(a.code)>6
order by b.code
查出来的什UPDATE到user表中的ID列,UPDATE语句要怎样写呢?update user set id=(select b.itemid
from user a
left join agency b on a.test = b.code
where length(a.code)>6
order by b.code)
可以这样写吗?但会提示缺少右括号
select b.itemid
from user a
left join agency b on a.test = b.code
where length(a.code)>6
order by b.code
查出来的什UPDATE到user表中的ID列,UPDATE语句要怎样写呢?update user set id=(select b.itemid
from user a
left join agency b on a.test = b.code
where length(a.code)>6
order by b.code)
可以这样写吗?但会提示缺少右括号
from user a
left join agency b on a.test = b.code
where length(a.code)>6
order by b.code
这句有多条记录吧?
update user set id=(
select itemid from agency where code=user.test
and length(a.code)>6
);
update user set id=(
select itemid from agency where code=user.test
and length(user.code)>6
);
若只有一行可以不使用order by
在指定了 TOP-n 时才能在子查询指定 ORDER BY。
update t_causer t set t.USERDATA=('2010-01-01'),提示类型不匹配,要怎么转换呢?
set ..= to_date('2010-01-01','YYYY-MM-DD');