What is the query to retrieve all employees whose name has a String "au"?

 Posted by Bharathi Cherukuri on 4/30/2012 | Category: Sql Server Interview questions | Views: 1541 | Points: 40
Answer:

The query to retrieve all employees whose name has a String "au" is as follows:

SELECT *  

FROM employees emp
WHERE emp.firstname LIKE ‘%au%’;


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response