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
- 3685 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
What is bcp? When does it used?
What is inline table-value user-defined function?
What is the advantage of sql server?
What is the command to change the recovery model?
How to execute a sql statement using mssql_query()?
What happens if the update subquery returns no rows in ms sql server?
What are the advantages of mirroring?
What are the steps you should follow to start sql server in single-user mode?
How many types of subqueries are there in sql server?
What are the recovery models for a database?
Explain the disadvantages/limitation of the cursor?
What is database isolation in sql server? : sql server database administration
What are the export options of ssrs?
What happens if null values are involved in arithmetic operations?
How many full-text indexes can a table have?
