93. select c_name, clsname from studata inner join score using (s_id) where score.math > 90; 下列那個 SQL 指令可和上述 SQL 指令得到相同的查詢結果?
(A)select c_name, clsname from studata inner join score having studata.s_id =score.s_id and score.math>90;
(B)select c_name, clsname from studata where studata.s_id=score.s_id and score.math>90;
(C)select c_name, clsname from studata, score where score.math>90;
(D)select c_name, clsname from studata, score where studata.s_id=score.s_id and score.math>90;

答案:登入後查看
統計: A(18), B(24), C(15), D(88), E(0) #2320330

詳解 (共 1 筆)

#5382692
那我們如何對函數產生的值來設定條件呢?舉...
(共 695 字,隱藏中)
前往觀看
3
0