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
- 11802 Views
- Hewitt, I also Faced
- E-Mail Answers
Answer Posted / ankit misra
the result will depend upon the type of join it carry 150 rows if its a full outer join,it will carry common rows if its a natural join.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
Does a sql server 2005 select statement require a from?
How do you rebuild an identity column?
Can we shrink data file in sql server?
What is sleeping status in sql server?
What are the properties of the relational tables?
What is row_number () and partition by in sql server?
How do triggers work?
how to invoke a trigger on demand? : Sql server database administration
What is purpose of normalization?
Tell me what is the order in which the sql query is executed?
how you can get the list of largest tables in a database? : Sql server administration
Explain how to send email from sql database?
What it means to be triggered?
How do I find the query plan in sql server?
