Question

What will be the output of the query? 

SELECT * FROM products WHERE product_name LIKE 
'App%';

Options

• Details of all products whose names start with 'App'.

• Details of all products whose names end with 'App'.

• Names of all products whose names start with 'App'.

• Names of all products whose names end with 'App'.

Answer 1

Details of all products whose names start with 'App'.

Explanation:

The LIKE operator in SQL searches for a pattern in a column. The % symbol serves as a wildcard, matching zero or more characters. 'App%' indicates that the product name must begin with "App" and may be followed by any sequence of characters (or none).