IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF
SELECT * FROM EMP,DEPT;
- 1 Answers
- 5060 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
Why select is used in sql?
Is sqlite free?
What are two statement types in sql?
what is row? : Sql dba
what is bcp? When does it used? : Sql dba
How does cross join work?
What is the difference between explicit and implicit cursors in oracle?
Can two tables have same primary key?
Is pl sql different from sql?
Explain autonomous transaction.
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
Can we connect to postgresql using sql developer?
How to process query result in pl/sql?
who introduced sql?
Is left join same as inner join?
