2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Co

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

2 Answers
4958 Views
Synechron, TCS, I also Faced
E-Mail Answers

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 do you delete duplicate rows in sql server?

0 Answers

what is statistics

1 Answers

Is mysql the same as sql server?

0 Answers

What is a domain constraint give an example?

0 Answers

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

0 Answers

What is the default order of an order by clause?

0 Answers

Explain different types of lock modes in sql server 2000?

0 Answers

What are the types of model in sql server and explain

2 Answers TCS,

How to find table changes in sql server?

0 Answers

What is a DBMS, query, SQL?

0 Answers Maveric,

I have a website that allows customers to browse and place orders for certain products. I have 2 tables; Customers and Orders. The Customers table holds the customer records and the Orders table holds the orders placed by the customer. Both tables are tied based on the field Cust_ID. Example of the data is shown below: Cust_ID Cust_Name Cust_ID Product Amount Order_Date 1001 John Tan 1001 P-5211 $120.00 2/13/2006 1002 Michael Wong 1001 K-1428 $88.90 1/11/2006 1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006 1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006 Write a single SQL statement that extracts all purchase records with the following criteria: 1. Customer names starting with “M” only. 2. Orders placed within the current month only. 3. Amount does not exceed $100.00 The list must be sorted by order date with the latest order showing on top.

3 Answers Techno Solutions,

What is microsoft sql server?

0 Answers

For more SQL Server Interview Questions Click Here