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

check whether all the emp numbers are indeed unique.

Question Posted / eswar

Answer Posted / eswar

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the need of a partition key?

728

How do you sort in sql?

774

How does postgresql compare to oracle/db2/ms sql server/informix?

772

What is hibernate and its relation to sql?

787

What are the types of dbms?

718

What is the difference between function, procedure and package in pl/sql?

763

What is sap sql anywhere?

680

what is self join and what is the requirement of self join? : Sql dba

857

What is the file extension for sql database?

669

How do I run a pl sql program?

800

What does select count (*) mean in sql?

738

What do you mean by stored procedures? How do we use it?

712

What is substitution variable in pl sql?

693

Explain scalar functions in sql?

772

What are basic techniques of indexing?

1069