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: 2999 | 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

Bookmark It

< Previous : Can we call a Trigger in store procedure ?

Next > : What is the query to retrieve first name and sum o ...

More Interview Questions by Bharathi Cherukuri

Latest Interview Questions