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
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
Can we use pragma autonomous_transaction in trigger?
Mention the differences between local and global temporary tables.
What is an inner join?
Do comments need to go in a special place in sql server 2005?
List few advantages of stored procedure.
Where actually sql azure database is hosted?
Explain the steps needed to create a scheduled job?
Can we add our custom code in ssis?
How global temporary tables are represented and its scope?
What is coalesce in sql server?
What is mean by candidate key?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How is a full-text index updated?
What are different types of table joins?