How maney row would be print after join if A table have 100
rows and B table have 50 rows...
- 9 Answers
- 9552 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
Ms sql server index?
What happens if ntwdblib.dll is missing on your machine?
System requirements for sql server 2005 express edition?
Can we use where and having clause together?
What is data compression?
How to send a ssrs report from ssis?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What is dynamic cursor in SQL SERVER?
If we delete pack Spec what will be the status of pack Body ?
Explain the properties of a relational table?
How to populate a table in sql server?
how can you attach more than 20 ldf files in sql server
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What are the steps to insert a table?
