in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.
Answer Posted / faridha
select * from emp where ename like 'J%' or '%J' and
not like ('arjun','jagadesh','niranjan','anju','aaaj');
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is a trigger and types of a trigger?
Where the sql logs gets stored?
What is 1nf normalization form?
Explain magic tables in sql server?
What are different types of roles provided by ssrs?
Explain a differential backup?
What is the default Port No on which SQL Server listens?
What is measure group, measure? : sql server analysis services, ssas
What happens if an integer is too big for int date type?
What is openxml in sql server?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
How to get nth highest salary from employee table.
Do you think BCNF is better than 2NF & 3NF? Why?
Does any body please help me what question's have asked for SSRS in the interview?
What is transaction server explicit transaction?