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

What it means to be triggered?

0 Answers  

What is snapshot replication?

0 Answers  

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

0 Answers  

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).

9 Answers   ADP,

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

0 Answers  




write sql program to get the detail of student in a class?

2 Answers  

How to transfer data from a cursor to variables with a "fetch" statement?

0 Answers  

i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 Answers  

What is a trigger and its types?

0 Answers  

What does truncate do?

0 Answers  

Why I can not enter 0.001 second in date and time literals in ms sql server?

0 Answers  

How do I find the port number for sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories