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
How to replace null values in expressions using isnull()?
How adventureworkslt tables are related?
What are the types of database schema? : sql server analysis services, ssas
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What are the differences between having and where clause.
Explain different types of Normalization.
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Why do we use trigger?
how to define testing of network layers? : Sql server database administration
Different types of keys in SQL?
How do you rebuild an identity column?
Define tempdb database?
How do you create a clustered index?
What are the restrictions that views have to follow? : SQL Server Architecture
Which rendering formats are affected by the pagesize properties?