in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answer Posted / ashok
select * from employee where name like=%'j'%
Thanx
Ashok
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
What is the standby server?
What is resource db in sql server?
What are the differences between left join and inner join in sql server?
Do you know what is sql injection?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
What is the temp table?
Tell me what is fill factor?
What is schemabinding a view?
What is set nocount on?
Why I am getting this error when dropping a database in ms sql server?
What are date and time data types in ms sql server?
Tell me the phases a transaction has to undergo?
Do you know concepts and capabilities of sql server?
What is left outer join in sql server joins?