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
- 5459 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
Define join and name different types of joins?
when is the use of update_statistics command? : Sql dba
What is a scalar value in sql?
How can we implement rollback or commit statement in a trigger?
How do I remove sql plus from windows 10?
what is normalization? : Sql dba
Can variables be used in sql statements?
what is self join and what is the requirement of self join? : Sql dba
How do I remove duplicates in two columns?
What is a procedure in pl sql?
How many joins in sql?
What are stored procedures used for?
Mention what does the hierarchical profiler does?
What is the command used to fetch first 5 characters of the string?
What is localdb mssqllocaldb?
