Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of passing name-value pairs as parameters?

1104


What is the difference between deallocate cursor and close cursor?

1167


How can we determine what objects a user-defined function depends upon?

950


Can multiple columns be used in sql group by clause in ms sql server?

985


How to loop through result set objects using odbc_fetch_row()?

919


What is command parameter in ssrs?

153


can a database be shrunk with users active? : Sql server administration

951


Tell me what is log shipping?

935


What is temporary table in sql server? Why we use temp table?

906


Can you pass expressions to function parameters?

1031


What is log in sql server?

1076


What is efficiency data?

904


What is sql profiler. What are the default templates with it? : sql server database administration

950


Explain atomicity?

973


What are the types of dml?

930