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
- 9346 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 are the different types of SSRS reports?
Differentiate between ms sql server reporting services vs crystal reports?
What is data file in computer?
Create and insert into temp table in sql server?
How many types of subqueries are there in sql server?
What are the Advantages of using CTE in sql server?
What is the current pricing model of SQL Azure?
How to get the definition of a view out of the sql server?
Tell me something about security and sql azure?
What are the differences between left join and inner join in sql server?
When is the use of update_statistics command?
Can you roll back the ddl statement in a trigger?
What is dbcc?
What is a virtual table in sql?
How to use linked server?
