Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 know whether our backup is succesfully taken?

1 Answers  

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

0 Answers  

What is a data source file?

0 Answers  

How do I find information about the install locations for the various instances running on a computer?

0 Answers  

What is molap and its advantage? : sql server analysis services, ssas

0 Answers  

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

0 Answers  

Explain “not null constraint” in sql server?

0 Answers  

what r steps to we need to fallow b4 kill the process?

1 Answers   Verizon,

How to add code to the existing article (using improve article)?

0 Answers  

What language is sql server written in?

0 Answers  

What is a data source or ds? : sql server analysis services, ssas

0 Answers  

How to list all user defined functions in the current database?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories