Kizspy | Question: 32
(Choose 3 answers)
With SQL, how do you select all the records from a table named "tblDepartment" where the value of the
column "depName" is "E&D department"?
Choose correct answers.
A. SELECT * FROM tblDepartment WHERE depName LIKE "%E&D department"
B. SELECT * FROM tblDepartment WHERE depName = "E&D department"
C. SELECT * FROM tblDepartment WHERE depName LIKE "E&D department"
D. SELECT * FROM tblDepartment WHERE depName = "%E&D department%"
