in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

Answer Posted / ashok

select * from Emp where name like '%j%'

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between function and stored procedure in sql server?

585


How do I find the transaction log size in sql server?

607


What is scheduled job and how to create it?

651


Explain about service Broker functions?

687


Define views.

681






Explain nested join?

647


Define tempdb database?

678


What is a ddl statement?

603


what is a join? : Sql server database administration

639


What is row_number () and partition by in sql server?

620


What is sql server locking?

619


What is trigger explain with program?

626


Explain indexing and what are the advantages of it?

621


Can you name some of the dml commands in sql?

648


Explain few examples of RDBMS?

684