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

Name the different type of indexes in sql?

972

What new changes are being made in SQL Server?

1198

What is the use of stored procedure?

944

How to disconnect from a sql server using mssql_close()?

1115

Do you know what are various aggregate functions that are available?

1134

What Are the Main Features of SQL Azure?

117

How many types of functions are there in sql server?

951

What is a cursor, index in sql?

1080

What do you mean by 'normalization'?

1072

Can binary strings be used in arithmetical operations?

943

How to copy the tables, schema and views from one sql server to another?

1055

List the ways in which dynamic sql can be executed?

1020

Explain iaas, paas and saas?

What is the use of keyword with encryption. Create a store procedure with encryption?

969

What are partitioned views?

1010