Interested to Buy Any Domain ? << Click Here >> for more details...
IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF
SELECT * FROM EMP,DEPT;
- 1 Answers
- 5467 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
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
Does sql use python?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
Does truncate need commit?
What is cascade in sql?
Is it possible to pass parameters to triggers?
how can we optimize or increase the speed of a mysql select query? : Sql dba
What found sql?
difference between anonymous blocks and sub-programs.
What is the process of copying data from table a to table b?
what is the difference between a local and a global temporary table? : Sql dba
What is orm in sql?
What are the different types of sql commands?
How does one use sql*loader to load images, sound clips and documents? : aql loader
Why is sql important?
