in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
- 8 Answers
- 7709 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 the default fill factor value?
Explain how to use linked server?
Explain what is “asynchronous” communication in sql server service broker?
What are the default system databases in sql server 2000?
How to insert data into an existing table?
What is the difference between a view and a stored procedure?
How do I delete a sql server database?
‘Order by’ is not allowed in a view how can you sort information from a view?
How to download microsoft sql server 2005 express edition?
what are the different stages of Report Processing?
What area unit the various kinds of info compression introduced in sql server 2008?
What is the difference between a "where" clause and a "having" clause?
What is the difference between functions and scalar functions?
What are the advantages dts has over bcp?
What types of Joins are possible with Sql Server?
