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 steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1049


How to get the definition of a stored procedure back?

979


create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

959


What is difference between materialized view and view?

919


Indexes are updated automatically is the full-text index also updated automatically?

1034


What is sql server agent and what are the two modes of authentication in sql server?

1064


What are the limitations/drawbacks or ssrs 2008 r2?

140


Define self join in sql server joins?

960


How do I run a trace in sql server?

994


what is the system function to get current user's user id? : Sql server database administration

1011


What is the purpose of grouping data in a report?

971


What is plan freezing?

977


What is updatable resultset?

1016


what method you can use to reduce the overhead of Reporting Services data sources?

258


What is the difference between the application object and session object?

1082