select * from emp where ename like 'J%' or '%J' and no

in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.

Question Posted / faridha

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

Please Help Members By Posting Answers For Below Questions

What is a trigger and types of a trigger?

1031

Where the sql logs gets stored?

1035

What is 1nf normalization form?

1084

Explain magic tables in sql server?

1107

What are different types of roles provided by ssrs?

156

Explain a differential backup?

1065

What is the default Port No on which SQL Server listens?

1178

What is measure group, measure? : sql server analysis services, ssas

1074

What happens if an integer is too big for int date type?

1029

What is openxml in sql server?

1224

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1116

How to get nth highest salary from employee table.

1211

Do you think BCNF is better than 2NF & 3NF? Why?

1342

Does any body please help me what question's have asked for SSRS in the interview?

2204

What is transaction server explicit transaction?

1089