How maney row would be print after join if A table have 100
rows and B table have 50 rows...
- 9 Answers
- 12264 Views
- Hewitt, I also Faced
- E-Mail Answers
Answer Posted / rajesh kannan.m
actually it is natural join.if two table is there like A and B
the natural join is A*B.A=100,B=50.so ans is 100*50=5000 rows.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between for xml raw and for xml auto?
What is a view in sql?
Equi join and non equi join is possible with sql server?
Can we do dml on views?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
List out the different types of locks available in sql server?
Can one drop a column from a table?
What is subquery? Explain the properties of a subquery?
What is a coalesce function?
How to remove duplicate rows from table except one?
What are the different subsets of sql?
Why we use the openxml clause?
What are the properties of the transaction?
