in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answer Posted / muthu kumar
select * from emp where empname like '%j%'
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
What are the two authentication modes in sql server?
How to create stored procedures with parameters in ms sql server?
When do you think a developer should use sql server-based cursors?
What is the sql server agent?
Can you please explain the difference between function and stored procedure?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
List out different types of normalizations in sql server and explain each of them?
Explain optimistic and pessimistic concurrency?
explain different types of constraints? : Sql server database administration
Differentiate between mongodb vs. Sql server?
What is sql server locking?
What is sql server query analyzer?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
What are views in ms sql server?
What is difference between equi join and natural join?