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 |
optimization techinques
List the different normalization forms?
How to create user defined functions with parameters?
What happens if null values are involved in datetime operations?
how to generate XML out of QUERY?
How to select an exiting database using mssql_select_db()?
How to write a query with a left outer join in ms sql server?
An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).
Can a unique index be created on a column, which contains null?
Does group by sort data?
What is sql server schema compare? How we can compare two database schemas?
How to maintain a fill factor in existing indexes?