A.聯(lián)合查詢(xún) B.內(nèi)連接 C.外連接 D.自連接
A.SELECT name FROM sh_goods_category WHERE id=(SELECT category_id FROM sh_goods WHERE name=’智能手機(jī)’); B.SELECT name FROM sh_goods_category WHERE id IN(SELECT category_id FROM sh_goods); C.SELECT id,price,score FROM sh_goods WHERE(price,score)=(SELECT MAX(price),MIN(score) FROM sh_goods); D.以上答案都不正確
A.MyISAM表B.InnoDB表C.MEMORY表D.以上答案全部正確