Answer Posted / colin
A small error kuldeep..if left table has 10 rows n right
table has 8 rows..then a cross join wud return 80 rows
(10*8)..besides dis ur totally ryt.. Cross joins are also
called cartesian product..
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain system scalar functions?
What the difference between UNION and UNIONALL?
Mention the different authentication modes in sql server.
What is a cube? : sql server analysis services, ssas
Does index slows down insert statements?
What is self contained multi valued query?
What is the synonym of join?
Which is the latest version of sql server and when it is released?
What is scan table/view and seek table/view when its occurs? : sql server database administration
Can we insert data if clustered index is disabled?
what is a self join? Explain it with an example? : Sql server database administration
Name few of the dcl commands in sql?
What is merge statement?
What is nolock hint in sql server 2008
How to provide login information for a new odbc dsn?