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?
- 7 Answers
- 11948 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer Posted / dharmendra singh
Concept of cross join
the result will be 10 bcos 5*2 = 10
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is the use of non clustered index?
Are subqueries better than joins?
how to enter binary numbers in sql statements? : Sql dba
What are different sql data types?
What is hibernate and its relation to sql?
What is coalesce sql?
What is varchar used for?
Enlist some predefined exceptions?
What is bitemporal narrowing?
What are different types of indexes?
What does select top 1 do in sql?
Is nosql relational?
What is difference between left and right outer join?
What do you understand by case manipulation functions?
What is the difference between partition and index?
