IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF
SELECT * FROM EMP,DEPT;
- 1 Answers
- 4797 Views
- I also Faced
- E-Mail Answers
Answer Posted / shailesh
Cartetian product i.e. 8 rows will be returned.
| Is This Answer Correct ? | 26 Yes | 0 No |
Post New Answer View All Answers
Explian rowid, rownum?
How do you determine the current isolation level? : Transact sql
What is the use of primary key?
Why is theta join required?
What are the possible values for the boolean data field?
What is a field in a database?
What does an inner join do?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is sql and its types?
What is a dynamic query?
What is a sql statement?
Is sql injection illegal?
what is sql server agent? : Sql dba
what is the difference between sql and t-sql? : Transact sql
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
