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 the difference in login security modes between v6.5 and 7.0? : Sql server database administration

0 Answers  


Does union all remove duplicates?

0 Answers  


How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

0 Answers  


Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,


Explain the difference between function and stored procedure?

0 Answers  






Give an example of SQL injection attack ?

0 Answers   HAL,


List out different types of normalizations in sql server and explain each of them?

0 Answers  


What language is sql server written in?

0 Answers  


Is it possible to update the views? If yes, how, if not, why?

0 Answers  


In clustered and non clustered indexes which one is faster while executing a query ?

1 Answers  


What are the different types of backups avaialabe in sql server 2005?

0 Answers  


wat is mean by trigger?.......normally wat use......when trigger used in sql........... plz cleary say with example.......

2 Answers   TCS, Wipro,


Categories