in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answer Posted / kalpana
select * from emp where name like '%J%'
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Explain important index characteristics?
What is SQL Azure?
What is the use of sql profiler in sql server 2012?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
what is a correlated sub-query? : Sql server database administration
How is sql server used?
What are the methods used to protect against sql injection attack?
What are cascading parameters in ssrs reports?
How does using a separate hard drive for several database objects improves performance right away?
How to locate and take substrings with charindex() and substring() functions?
What are the steps to follow to configure SQL*Net?
How to select true false based on column value in sql server?
What is the difference between a function and a trigger?
Explain what are magic tables in sql server?
What are the recovery models for a database?