COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
SELECT * FROM Persons WHERE LastName BETWEEN ‘Hansen’ AND ‘Pettersen’
|
|
|
SELECT * FROM Persons WHERE LastName>’Hansen’ AND LastName<’Pettersen’
|
|
|
SELECT LastName>’Hansen’ AND LastName<’Pettersen’ FROM Persons
|
|
|
None of the above
|
Detailed explanation-1: -With SQL, how do you select all the records from a table named “Persons” where the “LastName” is alphabetically between (and including) “Hansen” and “Pettersen"? SELECT * FROM Persons WHERE LastName BETWEEN ‘Hansen’ AND ‘Pettersen’; Which SQL statement is used to return only different values?
Detailed explanation-2: -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-3: -Hi dear, Answer:-SELECT * FROM Persons WHERE FirstName=’Peter’ AND LastName=’Jackson’ This query selects all the records from a table named “Person…
Detailed explanation-4: -SELECT statements An SQL SELECT statement retrieves records from a database table according to clauses (for example, FROM and WHERE ) that specify criteria. The syntax is: SELECT column1, column2 FROM table1, table2 WHERE column2=’value’;