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...

Consider the table T1 it consits
A,2,3,4
consider another table t2 it contain
1,2a,3a,4a
now i need o get the upadted answer

Answer Posted / rajesh

to get zero u must apply intersect set statement between
select statements of table1 and select statement of table2
syntax:
select * from t1
intersect
select * from t2

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to connect php with different port numbers?

1061


How to connect ms access to sql servers through odbc?

1008


Define inner join in sql server joins?

1041


What is dirty read?

1067


What are the five major components of a dbms?

920


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1986


When I run the sql server 2000 setup, it just hangs. What do I do?

1065


How to view existing indexes on an given table using sp_help?

1107


What are the differences between DDL, DML and DCL in SQL?

1206


Why use “pivot” in sql server?

1091


What are logical/boolean operations in ms sql server?

1016


How to find the version of sql server? : sql server database administration

1087


Explain trigger and its types?

1051


List the different types of joins?

966


What are the main differences between #temp tables and @table variables and which one is preferred?

1063