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 ‘\_’
Answer:B
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 ‘\_’