SQL - There are 10 rows in Table A and 0 Rows in table B. Select * from A,BHow many rows will be retrieve

GeekInterview.com > Interview Questions > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 115 of 170

There are 10 rows in Table A and 0 Rows in table B.
Select * from A,B
How many rows will be retrieved.

10 rows

Total Answers and Comments: 7

Last Update: June 30, 2008 Asked by: Eshwar

Sponsored Links

Best Rated Answer

—

Submitted by: avivbab2000

no rows selected

Above answer was rated as good by the following members:
spohilko

February 09, 2007 04:29:04

avivbab2000

RE: There are 10 rows in Table A and 0 Rows in table B...

no rows selected

Is this answer useful? Yes | No

1 0

Overall Rating: +1

February 16, 2007 09:14:34

Suganya

RE: There are 10 rows in Table A and 0 Rows in table B...

Hi,The basic funda in Oracle is Any addition,multiplication,division and joining two tables with one as null,Oracle will give the output only as Null.In your case there will be no rows selected.that is why the functionality of outerjoin is in Oracle.

Is this answer useful? Yes | No

February 19, 2007 14:56:04

akhil

RE: There are 10 rows in Table A and 0 Rows in table B...

no rows will be selected

Is this answer useful? Yes | No

February 20, 2007 04:38:00

kiran

RE: There are 10 rows in Table A and 0 Rows in table B...

No rows will be selected

Is this answer useful? Yes | No

March 12, 2007 09:17:05

nimisha agrawal

RE: There are 10 rows in Table A and 0 Rows in table B...

it will not select any row.coz according to this query it has to give cartesian product.that means it will select m into n rowsso 10*0=0

Is this answer useful? Yes | No

June 27, 2008 03:12:21

nandk.sharma

Member Since: June 2008 Contribution: 10

RE: There are 10 rows in Table A and 0 Rows in table B. Select * from A,BHow many rows will be retrieved.

no rows will be retrieved.
The Cartesian product will only yield records when there is atleast one record in both the tables i.e. A and B.

Is this answer useful? Yes | No

June 30, 2008 05:01:54

jasvinderss

Member Since: June 2008 Contribution: 1

RE: There are 10 rows in Table A and 0 Rows in table B. Select * from A,BHow many rows will be retrieved.

There could be two cases
(1) if you supply the query as Select * from A,B
you have not mentioned any join condition in this case 10 rows will be selected.
(2)if you supply a join condition with the above queries with a common filed between them, then in that case no rows will be selcted.

Is this answer useful? Yes | No

0 1

Overall Rating: -1

Go To Top