How maney row would be print after join if A table have 100
rows and B table have 50 rows...
- 9 Answers
- 10566 Views
- Hewitt, I also Faced
- E-Mail Answers
Answer Posted / saurav kumar
it returns common records between table A and table B, because if we use only join it behaves as a inner join in SQL Server
| Is This Answer Correct ? | 26 Yes | 0 No |
Post New Answer View All Answers
What is transaction server consistency?
What is store procedure? How do they work?
What is the use of keyword with encryption.
What is an inner join?
Does windows server 2016 come with sql server?
What are the steps you will take to improve the performance of a poor performing query?
What are security principals used in sql server 2005?
How to integrate the ssrs reports in application?
When you use @@error and try-catch?
What is transaction server auto commit?
What is the process of indexing?
Explain insert into select statement?
How many columns can exist together per table?
Does sql server use t sql?
How to use “drop” keyword in sql server and give an example?
