Interested to Buy Any Domain ? << Click Here >> for more details...
in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
- 8 Answers
- 9475 Views
- I also Faced
- E-Mail Answers
Answer Posted / deepa
For those who names starts with letter J is
select * from emp where name like 'j%'
For those who names with letter J is
select * from emp where name like '%j%'
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is a join in sql?
What is the difference between update lock and exclusive lock?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is sql server transaction log file?
List the types of recovery model available in sql server?
What happens if ntwdblib.dll is missing on your machine?
Is it important for a database administrator to understand the operating system and file access?
List some of the rules that apply to creating and using a ‘view’
What is collation?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
what is a self join? Explain it with an example? : Sql server database administration
What is the syntax to execute the sys.dm_db_missing_index_details?
Explain the functionalities that views support?
What do you understand by intent locks?
Explain in details security in SQL azure?
