Table left on SQL

[dr_gori]

Below a pearl in production:

Select all

select a.rowid, 
          a.nome as Area,  
          a.area_id as CodArea,  
          f.nopessoa as Nome,  
          f.cdpessoafunc as CodNome, 
          decode(a.ativo,'S','Sim','N','Não') as Ativo 
   from funcionarios f, area a, 
        solicitantes s 
   where a.responsavel = f.cdpessoafunc 
   group by a.rowid, a.nome, a.area_id, f.nopessoa, f.cdpessoafunc, a.ativo 
   order by 2;

Errors:
* The "requesters" table is not used at all! Just create a Cartesian product!
* To solve the problem, a group BY was placed, to eliminate the Cartiando product

Posted by Rodrigo Nascimento - Partnership

: - D

[DanielNN]

Post is old but problem is routine.

Time or another, in addition to these "Group By" to remove consultation failures (or bank modeling), I see things like:

Select all

SELECT DISTINCT 
... 
FROM 
... 
GROUP BY ....;

I think they think that group by with distinct gives double reinforcement for the inconsistencies and integrity of the bank.
: MRGreen:

[dr_gori]

Heoheoe
Yes, to ensure, put the distinct.

[DanielNN]

And we do not forget the "Rownum = 1" as the cake cherry. : lol :: lol :: lol: