Sign Up Login


  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 create a ddl trigger using "create trigger" statements?

0 Answers  

How to update multiple rows with one update statement in ms sql server?

0 Answers  

can we call functions from stored procedure in SQL Server 2005 ? How?

3 Answers  

What is normalization and denormalization in sql server?

0 Answers  

what is procedure in sql?

2 Answers   Millennium, SQL,




How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

0 Answers  

What is subquery in sql?

0 Answers  

How to disable stored procedure sql server?

0 Answers  

What number sorts of privileges are accessible in sql?

0 Answers  

Explain what are magic tables in sql server?

0 Answers  

What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  

Can we use where and having clause together?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories