You're designing a new SQL Server 2012 query for the HR department. The query will find records from the persons table for people whose name starts with 'Ja'. Which WHERE statement would be the correct choice?

 Posted by Bandi on 7/30/2014 | Category: Sql Server Interview questions | Views: 1465 | Points: 40
Select from following answers:
  1. where (name = 'Ja%')
  2. where (name like '%Ja%')
  3. where (name > 'Ja')
  4. where (name like 'Ja%')
  5. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response