COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
SELECT * FROM Persons WHERE FirstName=’a’
|
|
|
SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
|
|
|
SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
|
|
|
SELECT * FROM Persons WHERE FirstName=’%a%’
|
Detailed explanation-1: -With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”? Explanation: The SQL LIKE clause is used to compare a value to similar values using wildcard operators. 3.
Detailed explanation-2: -With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” is “Peter"? SELECT * FROM Persons WHERE FirstName=’Peter’; With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” starts with an “a"?
Detailed explanation-3: -Hi dear, Answer:-SELECT * FROM Persons WHERE FirstName=’Peter’ AND LastName=’Jackson’ This query selects all the records from a table named “Person…