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


Please Help Members By Posting Answers For Below Questions

Explain important index characteristics?

553


What is SQL Azure?

85


What is the use of sql profiler in sql server 2012?

511


how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

458


what is a correlated sub-query? : Sql server database administration

482






How is sql server used?

544


What are the methods used to protect against sql injection attack?

569


What are cascading parameters in ssrs reports?

176


How does using a separate hard drive for several database objects improves performance right away?

528


How to locate and take substrings with charindex() and substring() functions?

508


What are the steps to follow to configure SQL*Net?

559


How to select true false based on column value in sql server?

504


What is the difference between a function and a trigger?

571


Explain what are magic tables in sql server?

535


What are the recovery models for a database?

613