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 a self join in sql server?

0 Answers  


How to create a user name in a database?

0 Answers  


how to find number of columns in a table in sql server 2000 and 2005 also

16 Answers   Virtusa,


How to Generate a Series of Random Integers With T-SQL?

1 Answers  


Why is DML provided?

1 Answers   Ernst Young, Thomson Reuters,






What are built in functions?

0 Answers  


is it important for a database administrator to understand the operating system and file access? : Sql server administration

0 Answers  


What is the parse query button used for?

0 Answers  


What is the difference between having clause and where clause in sql server?

0 Answers  


What is Dependency Injection and provide example?

0 Answers  


How can you start sql server in different modes?

0 Answers  


As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  


Categories