Interested to Buy Any Domain ? << Click Here >> for more details...
How maney row would be print after join if A table have 100
rows and B table have 50 rows...
- 9 Answers
- 12105 Views
- Hewitt, I also Faced
- E-Mail Answers
Answer Posted / gowrishankar.s
join is used to join the two or more based on join tables.
in A table having 100 rows and b table having 50 rows in
this situation innerjoin join the related columns only.
select A.sutdid,B.empid, from A innnerJoin B
on A.studid=B.empid;
innerjoin is used retrieve all rows from both tables as
long as there is a matching between two columns.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to scale out a federation by Sql statement?
What are the source of constraints?
Explain features and concepts of analysis services?
How to declare and use cursor variables?
What factors you will consider calculating the storage requirement for that view?
Explain transaction server isolation?
What is the importance of three tier architecture?
What are the purpose of Normalisation?
What is data mart? : sql server analysis services, ssas
What are indexes in sql?
What is an active database?
wat wil hapn if we give the both read and deny read permission to user?
Where do we use trace frag?
Explain unique key in sql server?
How to find related tables in sql server?
