DBI202Xuất hiện trong 1 đề thi
Given two relations: PC(model, speed, ram, hd, type) Laptop(model, speed, ram, hd, screen, price) Which subquery gets the model of laptops with the same price as any PC?
Các lựa chọn
ASELECT model FROM Laptop WHERE price IN (SELECT price FROM PC);
BSELECT model FROM Laptop WHERE price = ALL (SELECT price FROM PC);
CSELECT model FROM Laptop WHERE price > ALL (SELECT price FROM PC);
DSELECT model FROM Laptop WHERE price < ALL (SELECT price FROM PC);