You need to extract details of those products in the SALES table where the PROD_ID
column contains the string ‘_D123’. Which WHERE clause could be used in the SELECT
statement to get the required output?
A.
WHERE prod_id LIKE ‘%\_D123%’ ESCAPE ‘\’
B.
WHERE prod_id LIKE ‘%_D123%’ ESCAPE ‘%_’
C.
WHERE prod_id LIKE ‘%_D123%’ ESCAPE ‘_’
D.
WHERE prod_id LIKE ‘%\_D123%’ ESCAPE ‘\_’