Cartetian product i.e. 8 rows will be returned.

IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF

SELECT * FROM EMP,DEPT;

Question Posted / shailesh

Answer Posted / shailesh

Is This Answer Correct ?

26 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are analytic functions in sql?

1074

What is difference between table and view?

1139

Is sqlite free?

1024

What are sql triggers used for?

1035

Is a secondary key the same as a foreign key?

1120

how can we optimize or increase the speed of a mysql select query? : Sql dba

989

Name three sql operations that perform a sort.

1066

What do you think about pl/sql?

1126

How much does sql certification cost?

1142

What is a left join?

1009

what are the different type of sql's statements ? : Sql dba

980

what are different types of keys in sql?

1221

What is set serveroutput on?

1184

what is schema? : Sql dba

1113

What is nvarchar max in sql?

1076