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

8 Answers
9368 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Does sql server 2000 clustering support load balancing?

950

plss anybody specify tha constrian management system in dbms

2128

How retrieve field names from the table in SQL through JAVA code?

1885

Please illustrate physical database architecture? : SQL Server Architecture

970

What are the source of constraints?

902

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

964

Can we return Data from 4(more than 1) tables in stored procedure?

1043

How to convert a table data in XML format in sql server?

2527

What is difference between count (*) and count 1?

914

What are the requirements to use odbc connections in php scripts?

1098

Which trace flags are enabled in sql server?

991

do views contain data ?

944

What is Extended user-defined?

945

Explain how many types of relationship?

1010

Can you pass expressions to function parameters?

1085