Ebay数据库面经分享加讨论

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

delete from Employee where rowid in (
. @8 G% p- \3 d6 ?5 ~  select rid from () M! V8 D3 f5 @0 ]1 @: x% z
    select rowid rid, 5 T, H/ y* l7 x
           row_number() over(partition by id,name,email order by id,name,email) as idx 6 c4 }+ s% N# R7 D4 ^
    from tab7)2 P! b6 G- U  \& Y& P
  where idx>1);

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

delete from employee a# z- i. s4 Z4 S8 Y
     where a.rowid > ANY(select b.rowid  D' w7 ?: w6 c' r% m( O" [* n
                                          from employee b* S) r6 U  O( E& ]/ E9 O) ^9 T
                                          where a.empid = b.empid)

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

you can use this: / G P! J. n# N9 P7 Z' o2 \
% O5 X3 c$ _3 @+ M7 K8 ?
select * from Employee group by Emp_id,Emp_name,Emp_email;

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

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