IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF
SELECT * FROM EMP,DEPT;
- 1 Answers
- 4940 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
what are the advantages of sql ? : Sql dba
how can you see all indexes defined for a table? : Sql dba
What is duration in sql profiler trace?
What do you mean by query optimization?
How do you declare a constant?
explain primary keys and auto increment fields in mysql : sql dba
What is the difference between the implicit and explicit cursors?
how do you know the version of your mysql server? : Sql dba
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What is pl sql variable?
Explain sql data types?
How can a function retun more than one value in oracle with proper example?
What is the difference between subquery and correlated query?
Can we create clustered index without primary key?
What is gpt format?
