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 the dbcc command and why is it used?

656

What are the different acid properties?

709

Describe in brief authentication modes in sql server.

654

how to trace the traffic hitting a sql server? : Sql server database administration

1274

What are the disadvantages of primary key and foreign key in SQL?

714

Can you import Microsoft Excel data to SSRS?

You want to implement the many-to-many relationship while designing tables. How would you do it?

651

Explain intellisense for query editing

667

What are various aggregate functions that are available?

589

How to download and install microsoft .net framework version 2.0?

635

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

693

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

609

What triggers long term care?

639

What are scheduled tasks in sql server?

648

What stored by the model? : sql server database administration

627