How maney row would be print after join if A table have 100
rows and B table have 50 rows...
Answers were Sorted based on User's Feedback
Answer / saurav kumar
it returns common records between table A and table B, because if we use only join it behaves as a inner join in SQL Server
Is This Answer Correct ? | 26 Yes | 0 No |
Answer / gowrishankar.s
join is used to join the two or more based on join tables.
in A table having 100 rows and b table having 50 rows in
this situation innerjoin join the related columns only.
select A.sutdid,B.empid, from A innnerJoin B
on A.studid=B.empid;
innerjoin is used retrieve all rows from both tables as
long as there is a matching between two columns.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / brajesh kumar srivastava
its depend on join what type join you are using,If You are
using cross join then 100*50 record would printed.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / ankit misra
the result will depend upon the type of join it carry 150 rows if its a full outer join,it will carry common rows if its a natural join.
Is This Answer Correct ? | 1 Yes | 3 No |
Answer / sachin
Case 1: not common rows
then Inner join A join B <> row
full outer join A join B = 100 row
full outer join B join A = 50 row
Case 2: common rows (10)
then Inner join A join B = 10
full outer join A join B = 100
full outer join B join A = 50
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / 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 |
Answer / 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 |
What is RAID and what are different types of RAID configurations?
How to use user defined functions in expressions?
What is the importance of concurrency control?
Explain what is “asynchronous” communication in sql server service broker?
How do I edit a stored procedure in sql server?
How can you see what type of locks used?
What is 'write-ahead log' in sql server 2000 ?
What is the difference between temp table and table variable?
What is normalization and its types?
Which sql server table is used to hold the stored procedure script?
What is difference in performance between insert top (n) into table and using top with insert?
wat will be the sql query to extract only last 3 records from table supose table hving thousands for records