問題詳情

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_idand score.math>90;
(B)select c_name, clsname from studata where studata.s_id=score.s_id andscore.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 andscore.math>90;

參考答案

無參考答案

內容推薦

內容推薦