Write an SQL statement: (i) To select the persons living in...

Write an SQL statement: (i) To select the persons living in a city that starts with 'S' from the 'Persons' table? (A) SELECT * FROM Persons WHERE city LIKE 's (B) SELECT FROM Persons WHERE city LIKE 's\%'. (C) SELECT FROM Persons WHERE city LIKE '\%s'. (D) SELECT FROM Persons WHERE city LIKE ' s\%'. (ii) To select the persons living in a city that contains the pattern 'tav' from 'Persons' table? (A) SELECT FROM Persons WHERE city LIKE '_tav_' (B) SELECT FROM Persons WHERE city LIKE '_tav\%'. (C) SELECT * FROM Persons WHERE city LIKE '\%tav_'? (D) SELECT * EROM Persons WHERE city LIKE '\%tav\%'. (iii) To select the persons whose last name starts with $" b$ 'or 's' or ' $p$ '? (A) SELECT * FROM Persons WHERE last-name LIKE 'b-s-p' (B) SELECT * FROM Persons WHERE last-name LIKE ' $b \% 5 \% p$ (C) SELECT * FROM Persons WHERE last-name LIKE ' $b \% s \% p \%$ ' (D) SELECT * FROM Persons WHERE last-name LIKE '[bsp]\%'

Write an SQL statement:
(i) To select the persons living in a city that starts with 'S' from the 'Persons' table?
(A) SELECT * FROM Persons WHERE city LIKE 's
(B) SELECT FROM Persons WHERE city LIKE 's\%'.
(C) SELECT FROM Persons WHERE city LIKE '\%s'.
(D) SELECT FROM Persons WHERE city LIKE ' s\%'.
(ii) To select the persons living in a city that contains the pattern 'tav' from 'Persons' table?
(A) SELECT FROM Persons WHERE city LIKE '_tav_'
(B) SELECT FROM Persons WHERE city LIKE '_tav\%'.
(C) SELECT * FROM Persons WHERE city LIKE '\%tav_'?
(D) SELECT * EROM Persons WHERE city LIKE '\%tav\%'.
(iii) To select the persons whose last name starts with $" b$ 'or 's' or ' $p$ '?
(A) SELECT * FROM Persons WHERE last-name LIKE 'b-s-p'
(B) SELECT * FROM Persons WHERE last-name LIKE ' $b \% 5 \% p$
(C) SELECT * FROM Persons WHERE last-name LIKE ' $b \% s \% p \%$ '
(D) SELECT * FROM Persons WHERE last-name LIKE '[bsp]\%'

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Key Concepts

SQL Pattern Matching Techniques

SQL pattern matching techniques involve the use of the LIKE operator combined with wildcard characters or bracket expressions, which can specify a range or set of characters. These techniques allow for sophisticated querying based on textual patterns in data.

Wildcard Characters in SQL

Wildcard characters, such as the percent sign (%) and the underscore (_), are used with the LIKE operator to represent one or more unspecified characters. These characters enable patterns to include any sequence or a single character, facilitating more versatile searches.

SQL WHERE Clause

The WHERE clause is used in conjunction with the SELECT statement to filter the records returned by the query. This clause specifies the conditions that the data must meet, allowing for focused retrieval of subsets of data.

SQL SELECT Statement

The SQL SELECT statement is the fundamental command used to retrieve data from one or more tables in a database. It allows you to specify the columns you wish to view from the table and forms the basis for most data querying operations.

SQL LIKE Operator

The LIKE operator is utilized within the WHERE clause to search for a specified pattern within column values. It is especially useful for partial matches and pattern-based searches, making it a key tool for flexible string querying.

Please give Ace some feedback