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

Answer Posted / bhavana

SELECT name FROM employee where name LIKE a%;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between count(*) and count(1) ?

811


What is sql server profiler?

744


What is perspective, have you ever created perspective? : sql server analysis services, ssas

673


What is bcp? When does it used?

730


How do I save a stored procedure in sql server?

670






What is failover clustering overview?

764


How to test subquery results with the exists operator?

747


When is update_statistics command used?

773


Write a query for primary key constraint with identity key word?

770


role of sql sever 2005 in database rather than any other database

1724


What is the maximum rows in sql server table?

670


What is key attribute?

699


Define synonym?

905


What part does database design plays a role in performance of an sql server-based application?

718


How do I find query history in sql server?

670