Estou com a seguinte dúvida......como faço um Select para achar os nome repetidos?
Exemplo da BD:
ID NOME
293050 Antonio Araujo
4434 António Araújo
262051 Eva Santos
5673 Eva Santos
Agradeço desde já
Abraço
Denni Serra.
ID NOME
293050 Antonio Araujo
4434 António Araújo
262051 Eva Santos
5673 Eva Santos
SELECT nome, count(id)
FROM tabela
GROUP BY nome
HAVING count(id) >1
SQL> SELECT EMPNO, JOB FROM EMP
2 /
EMPNO JOB
---------- ---------
7369 CLERK
7499 SALESMAN
7521 SALESMAN
7566 MANAGER
7654 SALESMAN
7698 MANAGER
7782 MANAGER
7788 ANALYST
7839 PRESIDENT
7844 SALESMAN
7876 CLERK
7900 CLERK
7902 ANALYST
7934 CLERK
14 rows selected.
SQL>
SQL> SELECT JOB, COUNT(EMPNO)
2 FROM EMP
3 GROUP BY JOB
4 HAVING COUNT(EMPNO)>1
5 /
JOB COUNT(EMPNO)
--------- ------------
CLERK 4
SALESMAN 4
MANAGER 3
ANALYST 2
SQL>
SQL> SELECT EMPNO, JOB
2 FROM EMP
3 WHERE JOB = ANY (SELECT JOB
4 FROM EMP
5 GROUP BY JOB
6 HAVING COUNT(EMPNO)>1 )
7 /
EMPNO JOB
---------- ---------
7934 CLERK
7900 CLERK
7876 CLERK
7369 CLERK
7844 SALESMAN
7654 SALESMAN
7521 SALESMAN
7499 SALESMAN
7782 MANAGER
7698 MANAGER
7566 MANAGER
7902 ANALYST
7788 ANALYST
13 rows selected.
SQL>
SQL> SELECT EMPNO, JOB
2 FROM EMP
3 WHERE JOB = ANY (SELECT JOB
4 FROM EMP
5 GROUP BY JOB
6 HAVING COUNT(EMPNO)>1 )
7 /
Usuários navegando neste fórum: Nenhum usuário registrado e 20 visitantes