Find all Employees who is having first letter of their last name as D-G ( i.e. D, E, F or G) ?

 Posted by Bandi on 9/30/2013 | Category: Sql Server Interview questions | Views: 1449 | Points: 40
Select from following answers:
  1. SELECT * FROM Employee WHERE LastName LIKE 'D%' OR LastName LIKE 'E%' OR LastName LIKE 'F%' OR LastName LIKE 'G%'
  2. SELECT * FROM Employee WHERE LastName LIKE '[D-G]%'
  3. SELECT * FROM Employee WHERE LastName LIKE '%[D-G]'
  4. 1 or 2
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response