DBI202Xuất hiện trong 1 đề thi
Given two relations:\nPC(model, speed, ram, hd, type)\nLaptop(model, speed, ram, hd, screen, price) \nWhich subquery gets the model of laptops with the same price as any PC?
Các lựa chọn
Asql\nSELECT model FROM Laptop WHERE price IN (SELECT price FROM PC);
Bsql\nSELECT model FROM Laptop WHERE price = ALL (SELECT price FROM PC);
Csql\nSELECT model FROM Laptop WHERE price > ALL (SELECT price FROM PC);
Dsql\nSELECT model FROM Laptop WHERE price < ALL (SELECT price FROM PC);