Which SQL operator tests if any of the sub-query value meets the condition ?

Ans : D

Solution

LIKE Operator

The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.

There are two wildcards often used in conjunction with the LIKE operator:

% - The percent sign represents zero, one, or multiple characters

_ - The underscore represents a single character

Syntax

SELECT column1, column2, ...FROM table_name WHERE columnN LIKE pattern;

AND Operator

The AND operator displays a record if all the conditions separated by AND are TRUE.

Syntax

SELECT column1, column2, ...FROM table_name WHERE condition1 AND condition2 AND condition3 ...;

OR Operator

The OR operator displays a record if any of the conditions separated by OR is TRUE.

Syntax​

SELECT column1, column2, ...FROM table_name WHERE condition1 OR condition2 OR condition3

IN Operator

The IN operator allows you to specify multiple values in a WHERE clause. The IN operator is a shorthand for multiple OR conditions.

IN Syntax

SELECT column_name(s) FROM table_name WHERE column_name IN (value1, value2, ...);