How maney row would be print after join if A table have 100
rows and B table have 50 rows...
- 9 Answers
- 10573 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
What is multi-statement table-value user-defined function?
How to delete existing rows in a table?
Explain differentiate between a having clause and a where clause?
How do use Having,Group by,Group function in SQL?
What is the difference between primary key and unique constraints?
Can primary key be null?
What are trace files?
What is sharding?
What is a fan-out query in SQL Azure?
What is best institute to Learn DotNET And SQL in chennai?
What is query and its types?
How do I make a resultset scrollable?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What are the properties and different types of sub-queries?
How will you know when statistics on a table are obsolete?
