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


Please Help Members By Posting Answers For Below Questions

How do I debug a stored procedure in sql server?

532


what is a join? : Sql server database administration

541


When would you use the stored procedures or functions?

574


What is the purpose of update statistics and scope_identity() function?

597


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

1549






What is a subquery in a select query statement in ms sql server?

582


what is an extended stored procedure? : Sql server database administration

494


How to provide default values to stored procedure parameters?

574


what are the important architecture components of SSRS?

92


Which is faster statement or preparedstatement?

526


ow to bring suspect mode datbase online from scratch

1402


Explain unique key in sql server?

536


How is sql used in sql server?

497


What is a rownum?

499


What is meant by indexing?

504