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 difference between drop truncate and delete?

1021

Explain the difference between delete,drop and truncate in SQL Server?

1022

What do you understand by integration services in sql server?

923

What is updatable resultset?

938

Do you know what are acid properties of transaction?

910

How to Sync Two SQL Azure Databases?

119

Explain how many types of relationship?

976

Write a SQL query in order to merge two different columns into single column?

992

What is ms sql server index?

1026

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

946

Explain the properties of a relational table?

980

What is report snapshot?

142

how would you store your query in an SSRS report or a Database server?

152

What is row_number () and partition by in sql server?

1007

What is transaction server implicit?

949