Which WHERE clause could be used in the

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 ‘_’

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.