COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which would find Pupils whose name begins in C from Haddon forms?
|
|
SELECT * FROM Pupils Where Name LIKE “C%” AND House = Haddon
|
|
|
SELECT * FROM Pupils Where Name = “C%” AND House = Haddon
|
|
|
SELECT * FROM Pupils Where Name = “C” AND House = Haddon
|
|
|
SELECT * FROM Pupils Where Name LIKE “C” AND House = Haddon
|
Explanation:
Detailed explanation-1: -To fetch the first alphabet from the strings, use LEFT(). This method allows you to return characters from the left of the string.
Detailed explanation-2: -The SQL statement would be: ename like ‘S%S’ .
Detailed explanation-3: -The SELECT statement is used to select data from a database. The data returned is stored in a result table, called the result-set.
There is 1 question to complete.