COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
SELECT surname FROM Pupils WHERE Smith
|
|
|
SELECT * FROM Pupils WHERE surname = Smith
|
|
|
SELECT * FROM Pupils WHERE surname = “Smith”
|
|
|
SELECT * FROM Pupils
|
Detailed explanation-1: -SELECT left(NAME, charindex(’ ‘, NAME)-1) AS ‘FirstName’, REVERSE(SUBSTRING(REVERSE(NAME), 1, CHARINDEX(’ ‘, REVERSE(NAME))-1)) AS ‘LastName’ FROM TABLE Error: Invalid length parameter passed to the LEFT or SUBSTRING function.
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: -SELECT statement uses * character to retrieve all records from a table, for all the columns. The above query will show all the records of student table, that means it will show complete dataset of the table.