Interested to Buy Any Domain ? << Click Here >> for more details...
How maney row would be print after join if A table have 100
rows and B table have 50 rows...
- 9 Answers
- 11810 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
Is it possible to create trigger on views?
Can a synonym name of a table be used instead of a table name in a select statement?
What are Spatial data types in SQL Server 2008
Why I am getting this error when dropping a database in ms sql server?
What is de-normalization and what are some of the examples of it?
How to create new tables with "select ... Into" statements in ms sql server?
what are the critical issues you have resloved in your company
What is partition index in sql server?
What is the security model used in sql server 2005?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
Why do you need a sql server?
Do you know what is difference between index seek vs. Index scan?
What is normalization 1nf 2nf 3nf?
Can you explain what is sql server english query?
Define left outer join in sql server joins?
