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

How to execute a stored procedure in ms sql server?

1164

Explain comment on transactions?

977

How to create an inline table-valued function?

965

What is a rollup clause?

965

What is difference between view and materialized view?

932

How do I find the sql server instance name?

963

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2219

What are ddl (data definition language) statements for tables in ms sql server?

1098

How to create stored procedures with parameters in ms sql server?

1076

What is change data capture (cdc) in sql server 2008?

1024

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

982

What is row_number function?

999

What is right outer join in sql server joins?

1181

Define cross join in sql server joins?

1019

How do you create a clustered index?

1050