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
- 11814 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
Explain timestamp datatype?
What is side by side migration in sql server?
explain how to create a new schema in a database? : Sql server database administration
What are the advantages of the mirroring?
What is field with example?
How many types of schemas are there?
What is use of except clause? How it differs from not in clause?
Explain what is sql server english query?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What are security principals used in sql server 2005?
Can a table be created inside a trigger?
What is database black box testing?
How to write an inner join with the where clause in ms sql server?
What happens if null values are involved in datetime operations?
How to rename databases in ms sql server?
