How maney row would be print after join if A table have 100
rows and B table have 50 rows...
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 merge replications?
What is the difference between createstatement and preparedstatement?
what is a deadlock? : Sql server database administration
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
What is clustered index
Is sql server a database?
explain different types of joins? : Sql server database administration
How real and float literal values are rounded?
What does the on update no action do?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
In which sql server version report builder introduced?
What are the fixed server level roles? : sql server security
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What is data file in computer?
What is the downside of using udf?