in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
- 8 Answers
- 8091 Views
- I also Faced
- E-Mail Answers
Answer Posted / kalpana
select * from emp where name like '%J%'
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are different types of subquery?
How global temporary tables are represented and its scope?
What is filestream?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What do you think of this implementation? Can this be implemented better?
What is explicit cursors?
What are “unrepeatable reads”?
Explain forward - only cursors?
What is implicit cursors?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
List some case manipulation functions in sql?
What is the difference between insensitive and scroll cursor?
What are the purposes of floor and sign functions?
List out the differences between the clustered index and non-clustered index in sql server?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
