哈哈，DAVY！我看到davy就進來了，沒想到真是你啊，而且也在blogjava安了家啊，給你上加上友情link了。在此祝賀你面試成功，送你四個字：你丫牛B。  回復  更多評論
  

我每次看別人貼子 我就想我現在 我是新手 我面試路好堅難了
努力 加油。  回復  更多評論
  

老大，你沒寫總結啊，你這寫的是筆試題目，連答案也不加上。  回復  更多評論
  

數據庫中有以下數據
ID(pri)(Auto) name pass
1 aaa 111
2 bbb 222
3 ccc 333
請用一條SQL語句將現有的三條記錄復制一下，達到以下的效果
ID(pri) (Auto) name pass
1 aaa 111
2 bbb 222
3 ccc 333
4 aaa 111
5 bbb 222
6 ccc 333
再用一條sql刪除重復記錄

select row_number() over(order by name) id,name,pass from tab order by name
union select row_number() over(order by name)+(select count(*) from tab) id,name,pass from tab order by name


select name, pass from (select row_number() over(order by name) id,name,pass from tab order by name union select row_number() over(order by name)+(select count(*) from tab) id,name,pass from tab order by name) t where name in (select name from (select row_number() over(order by name) id,name,pass from tab order by name union select row_number() over(order by name)+(select count(*) from tab) id,name,pass from tab order by name) t group by name having count(*) > 1)  回復  更多評論