A table named Emp is given below that contains data of an organization.
How many records will be displayed if the following SQL query is executed?
SELECT *
FROM Emp
WHERE Name BETWEEN ‘D’ AND ‘F’
A.
2
B.
A character column cannot be used in the BETWEEN operator.
C.
3
D.
4
Explanation:
The table given below shows the result of the query. The character column is compared against a
string using the BETWEEN operator, which is
equivalent to >= ‘D’ AND <=’F’. The name Flora will not be included because Flora is > F.
