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
- 4567 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 the difference between clustered index and primary key?
What are the options which must be set to allow the usage of optimistic models?
What are subqueries in sql server? Explain its properties.
What is query and its types?
How to create dbo table in sql server?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
What is mean by dml?
Explain how to send email from sql database?
What stored by the master?
What is buffer cash in sql server?
How to create prepared statements using odbc_prepare()?
Tell me what are the essential components of sql server service broker?
What is difference between Datepart() and Datename() in SqlServer?
How can I get data from a database on another server?
How to identify current user in ssrs report?
