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 proper subset of candidate key?

1039

What is use of except clause? How does it differ from not in clause?

1064

Explain what is analysis service repository?

1046

How many triggers are possible per table?

1139

What is the difference between sdf and mdf?

1351

How do I view a stored procedure in sql server query?

978

What is lock escalation? : sql server database administration

1196

What is catalog views?

1118

Explain foreign key in sql server?

1071

Explain about Normalization?

1120

Can two tables share the same primary key?

980

Does partitioning help performance?

994

How do I open port 1433?

984

What are the new features in sql server 2016?

1032

What is blocking and how would you troubleshoot it? : sql server database administration

1093