How maney row would be print after join if A table have 100
rows and B table have 50 rows...
Answer Posted / gopi muluka
My answer above assumes there are no common columns between
two table, in that case answer would be 5000 rows.
Otherwise Interviewer never mention about number of rows in
each table, If he is only interested in knowing what is the
default Join?
Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is code near application topology?
How to change the ownership of a schema in ms sql server?
What is page in sql server?
How to sort the query output with order by clauses in ms sql server?
Explain indexed views?
Can we store videos inside the sql server table?
How sql server executes a statement with nested subqueries?
Tell me what is the order in which the sql query is executed?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
How to add code to the existing article (using improve article)?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What are the system database in sql server 2008?
How do you manipulate data?
Mention the differences between local and global temporary tables.
How do you migrate data from mssql server to azure?