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

What is trigger and stored procedure in sql?

655

Can a primary key be a foreign key?

663

What is %type in sql?

606

How many disk partitions should I have?

636

What is the meaning of disabling a trigger?

724

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

650

How to place comments in pl/sql?

711

What is the use of function "module procedure" in pl/sql?

771

What is a boolean in sql?

617

how to check server status with 'mysqladmin'? : Sql dba

674

How do I edit a stored procedure?

641

What is the importance of sqlcode and sqlerrm?

970

Which data type is a composite type?

629

What is dense_rank in sql?

628

What is normalisation in sql?

650