How maney row would be print after join if A table have 100
rows and B table have 50 rows...
- 9 Answers
- 10572 Views
- Hewitt, I also Faced
- E-Mail Answers
Answer Posted / tnt
IF TWO TABLE A(100) AND B(50) ARE PARTICIPATE IN NO
SPECIFIC JOIN THEN IT WILL BE CROSS JOIN LIKE THIS
SELECT A.ROW,B.ROW FROM A,B
IT WILL GIVE 100*50 RESULT
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is the web service used for reporting services?
What is the security model used in sql server 2005?
What is scrollable cursor?
What is database mirroring?
What do you mean by an execution plan? Why is it used?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What is an expression in ms sql server?
How to create a simple table to test triggers in ms sql server?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What is attribute relationships, why we need it? : sql server analysis services, ssas
role of sql sever 2005 in database rather than any other database
what is raid? : Sql server database administration
Can a trigger be created on a view?
What is user-defined scalar function?
What is built-in/administrator?
