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 / santosh pashte
It is concept of CROSS JOIN..
It will display 5 * 2 = 10 rows
| Is This Answer Correct ? | 41 Yes | 4 No |
Post New Answer View All Answers
What is left join example?
What is the purpose of design view?
What are the benefits of pl/sql packages?
Can we use ddl commands in pl sql?
What is rownum?
What is the primary use of normalization?
How do I add a primary key to a table?
What is sql table?
What is the usage of when clause in trigger?
What are some emotional triggers?
What is write ahead logging in sql server?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
Which command is used to delete a trigger?
What is the order of sql select?
what is a join? : Sql dba