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 the difference between primary key and unique key? : Sql dba

1042

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

986

How to Declare Fixed Length String Value In PL SQL

1158

what are integrity rules?

1036

What is snowflake sql?

1079

How does postgresql compare to "nosql"?

1039

Why we use stored procedure instead of query?

1001

Is sql better than excel?

1160

What are the three pl sql block types?

1013

What type of join is sql join?

988

How to install oracle sql developer?

1055

How do you optimize a query?

1009

Why do we need a foreign key?

1103

What is data type in database?

1000

What are few of the schema objects that are created using PL/SQL?

1043