in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
- 8 Answers
- 8083 Views
- I also Faced
- E-Mail Answers
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 the significance of master, tempdb and model databases?
what are the different types of replication you can set up in sql server? : Sql server database administration
What is the syntax for encrypting a column in SQL Server?
Explain throw statement in sql server 2008?
What is a non-clustered index?
Name 3 ways to get an accurate count of the number of records in a table?
How to compare the top two records using sql?
What do you mean by sql server 2005 express management tools?
What are click through reports?
Difference between Logical Page and Physical Page in SSRS.
Explain system rowset functions?
What are advantages of ssrs or why we should use ssrs?
Do you have any idea about the tcl commands?
Which are the third-party tools used in sql server and why would you use them?
In what sequence sql statement is processed?
