Hi, Sandip.

Probably there are cases where fid is repeated in tadescritivegroup.

Regards,
Claudio.

-----Mensagem original-----
De: Sandip Parekh [mailto:oracledba-ezmlmshield-x51402631.[Email address protected]
Enviada em: sexta-feira, 30 de março de 2007 10:21
Para: LazyDBA Discussion
Assunto: Sql Count differences

can someone tell me why the two different bits of sql return two
different counts?
i would have thought that their output would be the same.

select count(m.fid) from topographicarea m, tadescriptivegroup t
where m.fid=t.fid and t.descriptivegroupid=310;
returns 16204

select count(m.fid) from topographicarea m where m.fid in
(select fid from tadescriptivegroup where descriptivegroupid=310);
returns 16137

Sandip

Email has been scanned for viruses and spam by Altman Technologies

---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page