Write an sql query to find the names of employees start with ‘a’?



Write an sql query to find the names of employees start with ‘a’?..

Answer / bhavana

SELECT name FROM employee where name LIKE a%;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is advantage data architect?

0 Answers  


How many levels of sp nesting is possible?

0 Answers  


There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,


ow to bring suspect mode datbase online from scratch

0 Answers  


sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters

1 Answers  






How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  


What are different types of raid levels?

0 Answers  


How many types of functions are there in sql server?

0 Answers  


What is database replicaion? What are the different types of replication you can set up in SQL Server?

5 Answers   Aptech, HCL, Perpetual, SAIC,


What does the update command do?

0 Answers  


Why we use functions in sql server?

0 Answers  


How do I find the sql server database version?

0 Answers  


Categories