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
- 11468 Views
- Hewitt, I also Faced
- E-Mail Answers
Answer Posted / gopi muluka
My answer above assumes there are no common columns between
two table, in that case answer would be 5000 rows.
Otherwise Interviewer never mention about number of rows in
each table, If he is only interested in knowing what is the
default Join?
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
what is the difference between openrowset and openquery?
Can we write a distributed query and get some data which is located on other server and oracle database?
How to get a list all databases on the sql server?
What is a trigger and types of a trigger?
What is the use of builtinadministrators group in sql server? : sql server security
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
Explain system scalar functions?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
How to disable stored procedure sql server?
What is RAID? What are the different types of RAID configurations?
Distinguish between commit and rollback?
What is the process of indexing?
Tell me what is fill factor?
How global temporary tables are represented and its scope?
How to create a store procedure with encryption?
