How maney row would be print after join if A table have 100
rows and B table have 50 rows...
- 9 Answers
- 9572 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 identity?
Explain error and transaction handling in sql server?
Using the customer, and order table in northwind database, please write a query to produce xml?
What happens if the update subquery returns no rows in ms sql server?
What is the function of inner join?
What is the simplest way to create a new database in ms sql server?
What is cross join in sql server joins?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
How to download and install sql server 2005 books online?
What is sub-query in sql server?
What are horizontal and vertical scaling?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
What do you understand by a stored procedure?
Describe the left outer join & right outer join. : sql server database administration
Name three of the features managed by the surface area configuration tool? : sql server security
