there is A table and B table in A table there 5 rows and in
b table there are 2 rows i am firing query select * from
a,b what will be the output?
Answer Posted / sirisha
5*2=10
Its a cartesian product
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
how to do backup entire database? : Transact sql
Which sorts rows in sql?
How do you exit in sql?
What is the difference between a subquery and a join?
What mean sql?
Does sql between include endpoints?
What is a primary key sql?
Why is stored procedure faster than query?
what are the differences among rownum, rank and dense_rank? : Sql dba
What is the difference between syntax error and runtime error?
Does asenumerable execute the query?
How to check if a column is nullable before setting to nullable?
What is a table?
What are predefined functions in sql?
What is tuple in sql?