Ebay数据库面经分享加讨论

woaini · 发表于 2-16-2017 11:10 AM

delete from Employee 1 h' k( O# `6 \' w5 v
where rowid not in (
. k, _0 B2 ]: C' ?select min(rowid) from Employee group by Emp_id
: }  m6 x! k  j% L5 J)

CathyLee · 发表于 2-16-2017 11:10 AM

How does a query delete something?

透明 · 发表于 2-16-2017 11:10 AM

how about select distinct * from from Employee

		自动登录	找回密码
密码			立即注册

[eBay-Paypal] Ebay数据库面经分享加讨论