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?
Answers were Sorted based on User's Feedback
Answer / santosh pashte
It is concept of CROSS JOIN..
It will display 5 * 2 = 10 rows
Is This Answer Correct ? | 41 Yes | 4 No |
Answer / manda
It gives a cartesian product or a cross product.
Is This Answer Correct ? | 11 Yes | 1 No |
Answer / mubin ahmad
select * from a,bwill be the out put in 10 rows
Is This Answer Correct ? | 11 Yes | 2 No |
Concept of cross join
the result will be 10 bcos 5*2 = 10
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / v.g.venkatesh babu
It gives error. If you want to access the data from two tables then we must use JOINS concept... so we need to use aliasis names for tables...
* so both tables A and B must have same no. of fields with same datatypes then only we can use joins.
*Both tables must associated with forign key...
Is This Answer Correct ? | 0 Yes | 4 No |
How collections are improve the performance?
What is Data Concarency and Consistency?
What are the built in functions of sql?
what are the advantages of package?
how can i create a user defined datatype
display your age in months?
Is json a nosql?
Is pl sql still used?
There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?
What trigger means?
What is compiled query?
What are the types of join in sql?