SQL question
- From: "Ramadoss, Karthik" <Karthik.Ramadoss@xxxxxxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Oct 2012 19:00:45 +0000
This is probably a simple one but definitely something new for me.
Database: 11.2.0.3
OS: Oracle Linux 5.6
A SQL like
SELECT A.COL1,
A.COL2,
B.COL3
FROM TABLE1 A,
TABLE2 B,
TABLE3 C
WHERE A.ID = B.ID AND B.ID = C.ID
returns 1,192,940 rows.
And
SELECT COUNT(*) from
(SELECT A.COL1,
A.COL2,
B.COL3
FROM TABLE1 A,
TABLE2 B,
TABLE3 C
WHERE A.ID = B.ID AND B.ID = C.ID)
Returns 1,192,978 rows.
Anyone know what is going on here? I would expect both to return the same
number of rows.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
