in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
- 8 Answers
- 7706 Views
- I also Faced
- E-Mail Answers
Answer Posted / ashok
select * from employee where name like=%'j'%
Thanx
Ashok
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
Does union all remove duplicates?
Where the sql logs gets stored?
What stored by the msdb? : sql server database administration
What are basics of policy management?
How to download and install the scaled-down database adventureworkslt?
what is a deadlock? : Sql server database administration
How to delete duplicate rows?
Why can there be only one clustered index and not more than one?
Tell me what is de-normalization and what are some of the examples of it?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
Explain what is use of dbcc commands?
What is statement level trigger?
What is row_number()?
Write the SQL query to drop, truncate and delete table.
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
