Which query lists only the staff who work in the district with DistrictID 7?

Quelle requête ne liste que les agents qui travaillent dans le district dont l'IDDistrict vaut 7 ?

Answers

ASELECT * FROM Staff ORDER BY DistrictID = 7;SELECT * FROM Staff ORDER BY DistrictID = 7;

BSELECT * FROM Staff GROUP BY 7;SELECT * FROM Staff GROUP BY 7;

CSELECT DistrictID 7 FROM Staff;SELECT DistrictID 7 FROM Staff;

DSELECT * FROM Staff WHERE DistrictID = 7;SELECT * FROM Staff WHERE DistrictID = 7;

The answer and explanation are in the full bank.

This question is one of 2,831 in the paid banks. Each comes with the correct answer and the reasoning behind it, not just a mark.

MIFOTRA exam practicealigned to Practice set: Database Management·1 mark·Easy

More Database questions