問題詳情
下列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)
用户評論