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
- 11463 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
Explain cross join or cartesian product in sql?
Is sql different from sql server?
Which joins are sql server default?
Is it possible to call a stored procedure within a stored procedure?
How to drop an existing stored procedure in ms sql server?
What is the difference between an index and a unique index?
Why I am getting this error when renaming a database in ms sql server?
What are 3 ways to get a count of the number of records in a table?
What is the default fill factor value?
What is sql view?
What is ms sql server reporting services?
You want to implement the one-to-many relationship while designing tables. How would you do it?
What is a mixed extent?
How to list all user names in a database?
Write a code to select distinct records without using the DISTINCT keyword.
