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 the difference between count and distinct count?
What is the difference between a function and a stored procedure?
hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.
What are the differences between local and global temporary tables?
How is table type constraint applied to a table?
What area unit the various kinds of info compression introduced in sql server 2008?
How to verify a login name with sqlcmd tool?
Why use triggers?
What do you mean by recursive stored procedure?
How do I run a trace in sql server?
How to sort query output in descending order in ms sql server?
Explain DBMS, RDBMS?