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
- 9261 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
How do I install sql server?
What stored by the model?
How do I completely remove sql server instance?
what's the maximum size of a row? : Sql server database administration
Explain the cursor lock types?
What are differences in between sql server 2012 and sql server 2016?
How to skip remaining statements in a loop block using continue statements?
Explain the working of sql privileges?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What are the advantages of using a stored procedure?
How do clustered indexes store data?
Tell me what do we need queues in sql service broker?
Do you know what is rank function?
Why SQL Agent is used?
What is the temp table?
