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 |
What is sql data?
How do I partition in sql?
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?
What is function and procedure?
How do rank () and dense_rank () differ?
How do you optimize SQL queries ?
6 Answers CarrizalSoft Technologies, Infosys, Oracle,
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What is PL/SQL table ?
Mention what are different methods to trace the pl/sql code?
What is the maximum number of triggers,can apply to a single table?
What is embedded sql with example?
What is sql*loader and what is it used for?