How maney row would be print after join if A table have 100
rows and B table have 50 rows...
Answer Posted / saurav kumar
it returns common records between table A and table B, because if we use only join it behaves as a inner join in SQL Server
Is This Answer Correct ? | 26 Yes | 0 No |
Post New Answer View All Answers
How to configure and test odbc dsn settings?
What is the purpose of the tempdb database?
What are different types of table joins?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
what are constraints? : Sql server database administration
How to delete multiple rows with one delete statement in ms sql server?
How can you find out how many rows returned in a cursor?
Mention the differences between local and global temporary tables.
Which trace flags are enabled in sql server?
How to count rows with the count(*) function in ms sql server?
How exceptions can be handled in sql server programming?
How do I get to sql server configuration manager?
Explain what are sparse columns?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What is the cpu pressure?