COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In the following SQL query, what is the wildcard? SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
|
|
*
|
|
|
%
|
|
|
SELECT
|
|
|
WHERE
|
Explanation:
Detailed explanation-1: -A wildcard character is used to substitute one or more characters in a string. Wildcard characters are used with the LIKE operator. The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.
Detailed explanation-2: -To broaden the selections of a structured query language (SQL-SELECT) statement, two wildcard characters, the percent sign (%) and the underscore ( ), can be used.
Detailed explanation-3: -Matches one or more characters. Note − MS Access uses the asterisk (*) wildcard character instead of the percent sign (%) wildcard character. Matches one character.
There is 1 question to complete.