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
- 9370 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 a data collection table?
What is cdc in sql server?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What are the advantages of user-defined functions over stored procedures in sql server?
Explain multiserver query
What do you understand by a view?
What is the difference between rank and dense_rank?
What are examples of triggers?
How to query multiple tables jointly?
Explain what is public role in sql server?
How to locate and take substrings with charindex() and substring() functions?
What is a data source file?
What is the ‘fillfactor’?
How to declare a cursor with "declare ... Cursor" in ms sql server?
What is a not null constraint?
