教甄◆資訊科技概論專業(電腦科)題庫下載題庫

上一題
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;



93. select c_name, clsname from studata ..-阿摩線上測驗