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

How do you declare a variable in pl sql?

967

What are the most important ddl statements in sql?

1027

what is the difference between primary key and unique key? : Sql dba

972

How many primary keys can a table have?

955

What packages are available to pl/sql developers?

996

Explain correlated query work?

992

What is the difference between joins?

977

what is a unique key ? : Sql dba

1028

Is sql a case sensitive language?

894

Can we create a trigger on view?

844

How many types of triggers are there in pl sql?

1016

Explain what is rdbms?

993

How long it takes to learn pl sql?

951

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1003

What is schema in sql example?

1091