問題詳情

下列SQL程式碼,何者為join的應用
(A)select stuid,stuname from stutable join to scotable where stutable.stuid=scotable.stuid
(B)select stutable.stuname,scotable.mathscore from stutable,scotable where stutable.stuid=scotable.stuid
(C)select stutable.stuname,score.mathscore where stutable.stuid=scotable.stuidinsert into stutable(stuid,stuname) values(123,’peter’)

參考答案

答案:B
難度:困難0.354839
統計:A(34),B(44),C(21),D(10),E(0)

內容推薦

內容推薦