select empno, count(empno) from emp group by empno having count(empno) &

check whether all the emp numbers are indeed unique.

Question Posted / nagendra

Answer Posted / nagendra

select empno, count(empno)
from emp
group by empno
having count(empno) > 1;

Is This Answer Correct ?

22 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

607

What is pivot in sql?

504

Which one is faster ienumerable or iqueryable?

473

Is it mandatory for the primary key to be given a value when a new record is inserted?

698

what are ddl statements in mysql? : Sql dba

570

Is sql workbench free?

522

What do you understand by pl/sql records?

526

What is prepared statement in sql?

539

How do you modify a table in sql?

553

Does inner join return duplicate rows?

512

What is a relationship and what are they?

569

What are the advantages of sql?

553

Is not equal in sql?

557

Does sql profiler affect performance?

547

What is sql query optimization?

535