How maney row would be print after join if A table have 100 rows and B table h

Categories >> Software >> Databases >> SQL Server
Suggest New Category

How maney row would be print after join if A table have 100
rows and B table have 50 rows...

Question Posted / ramlakhan

9 Answers
12129 Views
Hewitt, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How maney row would be print after join if A table have 100 rows and B table have 50 rows.....

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

How maney row would be print after join if A table have 100 rows and B table have 50 rows.....

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

How maney row would be print after join if A table have 100 rows and B table have 50 rows.....

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

How maney row would be print after join if A table have 100 rows and B table have 50 rows.....

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

How maney row would be print after join if A table have 100 rows and B table have 50 rows.....

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

How maney row would be print after join if A table have 100 rows and B table have 50 rows.....

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

How maney row would be print after join if A table have 100 rows and B table have 50 rows.....

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

How maney row would be print after join if A table have 100 rows and B table have 50 rows.....

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

How maney row would be print after join if A table have 100 rows and B table have 50 rows.....

Answer / gopi muluka

100*50 =5000 Rows

Is This Answer Correct ?

6 Yes

15 No

Post New Answer

More SQL Server Interview Questions

How to drop an existing stored procedure in ms sql server?

0 Answers

What is collation?

0 Answers

What is the maximum length of an alert name?

0 Answers

What are the differences between DDL, DML and DCL in SQL?

0 Answers ABB, Aspire, Infogain,

What is the stuff and how does it differ from the replace function?

0 Answers

What is SQL Profiler and the use of it?

2 Answers 247Customer,

What factors you will consider calculating the storage requirement for that view?

0 Answers

What are the differences between char and nchar in ms sql server?

0 Answers

tell me the disaster recovery plan

0 Answers Microsoft,

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

0 Answers TCS,

Explain the difference between delete,drop and truncate in SQL Server?

0 Answers HCL,

What is the default server name for sql server?

0 Answers

For more SQL Server Interview Questions Click Here