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

Question Posted / prashanth

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

More SQL Server Interview Questions

When cursors are useful?

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

Differentiate between a local and a global temporary table?

What is the recovery model? List the types of recovery model available in sql server?

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

Can I run multiple instances of sql server 2000 at the same time on one computer?

Where do we use trace frag?

What is an sql server agent?

how can we use a composite key for two tables and how can we represent it

Explain what is lock escalation and what is its purpose?

What is difference between equi join and inner join?

What is normalization and its types?

For more SQL Server Interview Questions Click Here