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
- 11801 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 about integration services of Microsoft SQL server?
List few advantages of stored procedure.
What program is used to store the data source file?
What do mean by xml datatype?
What is 2nf example?
What is openrowset sql server?
How many null values we can have in a unique key field in sql server?
How much space does sql server 2016 take?
What is query optimization process?
What is the fastest way to permanently delete a 1 million row table named customers?
Explain optimistic and pessimistic concurrency?
how many no of arguments can be passed in procedures and functions
What do you mean by acid?
Mention the differences between sql server and mysql.
Write SQL queries on Self Join and Inner Join.
