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

what are the Prerequisites for Replication?

11352

How can you control the amount of free space in your index pages?

1057

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1951

Do you know what are acid properties?

1079

How and why use sql server?

1007

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

111

How to download and install sql server 2005 books online?

1191

What are SSL and TSL protocols?

985

Differentiate between a having clause and a where clause.

965

What is the difference between primary key and unique constraints?

963

How to create new tables with "create table" statements in ms sql server?

1066

Can group functions be used in the order by clause in ms sql server?

1013

What is an expensive query?

931

How can I add Reporting Services reports to my application?

129

How to get the query of a table in sql server?

898