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
How to connect php with different port numbers?
How to connect ms access to sql servers through odbc?
Define inner join in sql server joins?
What is dirty read?
What are the five major components of a dbms?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
When I run the sql server 2000 setup, it just hangs. What do I do?
How to view existing indexes on an given table using sp_help?
What are the differences between DDL, DML and DCL in SQL?
Why use “pivot” in sql server?
What are logical/boolean operations in ms sql server?
How to find the version of sql server? : sql server database administration
Explain trigger and its types?
List the different types of joins?
What are the main differences between #temp tables and @table variables and which one is preferred?