Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

GATE | GATE MOCK 2017 | Question 60

  • Last Updated : 28 Jun, 2021

Which option is true about the SQL query given below?

SELECT firstName, lastName 
FROM Employee 
WHERE lastName BETWEEN 'A%' AND 'D%';

(A) It will display all the employees having last names starting with the alphabets ‘A’ till ‘D’ inclusive of A and exclusive of D.

Attention reader! Don’t stop learning now.  Practice GATE exam well before the actual exam with the subject-wise and overall quizzes available in GATE Test Series Course.

Learn all GATE CS concepts with Free Live Classes on our youtube channel.

(B) It will throw an error as BETWEEN can only be used for Numbers and not strings.
(C) It will display all the employees having last names starting from ‘A’ and ending with ‘D’.
(D) It will display all the employees having last names in the range of starting alphabets as ‘A’ and ‘D’ excluding the names starting with ‘A’ and ‘D’.


Answer: (A)

Explanation:

The BETWEEN operator works with the range of character values also.

Quiz of this Question

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!