1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

2) Consider a Table name A which has below records

ID
---
5
5
5
5
5
Consider another table B which has below records

ID
--
5
5
5
5
5
5
5
5
How many rows will be returned by each of the below queries
a) select * from A inner join B on A.id = b.ID
b) select * from A left join B on A.id = b.ID
c) select * from A right join B on A.id = b.ID

Question Posted / abhishek6555

Answers were Sorted based on User's Feedback



2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table..

Answer / abhishek6555

Solution :

a) 40 rows
b) 40 rows
c) 40 rows

http://abhishekgaikwadtech.blogspot.in/2015/07/t-sql-interview-question-2.html

Is This Answer Correct ?    14 Yes 0 No

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table..

Answer / swetha

40 rows but using cross join we can get no of rows

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to test values returned by a subquery with the in operator?

0 Answers  

Why use view instead of a table?

0 Answers  

Define outer join in sql server joins?

0 Answers  

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  




What is the purpose of the master database?

0 Answers  

Can we create a clustered index on composite primary key.

3 Answers   IGT,

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

3 Answers  

Detail about the hardware which is supported by SQL server?

0 Answers  

How can you insert null values in a column while inserting the data?

0 Answers  

What is 'Join' and explain its various types.

0 Answers   Genpact,

What are trace flags?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories