select * from table where columndata not in(select columndata from table w

which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM

Question Posted / sandeep rana

Answer Posted / sandeep rana

select * from table where columndata not in(select
columndata from table where date between '' and '')

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Which sql server table is used to hold the stored procedure scripts?

1109

What is the difference between drop table and truncate table?

973

Do you know what is replace and stuff function in sql server?

1082

What is meant by indexing files?

1090

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

1028

What are the different editions available in sql server 2000?

1111

What is federation member?

116

in the physical file layout, where should the transaction log be stored in relation to the data file?

1039

Does sql server use t sql?

1071

How to access the inserted record of an event?

1107

What do I need to start working with sql studio? : sql server management studio

1157

What does the on update no action do?

1077

Can we insert data if clustered index is disabled?

981

What are the different types of cursor?

1147

Do you know how to send email from database?

1045