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
- 3 Answers
- 4706 Views
- I also Faced
- E-Mail Answers
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
Explain syntax for viewing, dropping and disabling triggers?
Why do we use functions?
What is data block and how to define data block size?
What are indexers?
Explain the difference between function and stored procedure?
How to invoke a trigger on demand?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
Why functions are used in sql server?
What is the difference between Stored Procedures and triggers?
Explain foreign key in sql server?
Explain the use of containers in ssis and also their types?
What is wide table?
What do you understand by a stored procedure?
How to add the custom code in Report?
Define tool Manage Statistics in SQL Server 2000 query ?
