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 is checkpoint process in the sql server?
What are the steps you will take to improve the performance of a poor performing query?
How to choose all records from the table?
What are drilldown reports?
Tell me extended events in sql server 2008?
What is the synonym of join?
List the different types of joins?
what is memory-optimized nonclustered indexes
can an automatic recovery be initiated by a user? : Sql server administration
how to control the amount of free space in your index pages? : Sql server database administration
What is temporal data type?
Can you always create a cache of a report?
What is standby servers? Explain types of standby servers.
What stored by the model? : sql server database administration
Write a query for primary key constraint with identity key word?