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 denormalization. : Sql dba

1120

Why do we create stored procedures & functions in pl/sql and how are they different?

953

How insert into statements in sql?

1081

What's the procedure?

933

What is mutating trigger?

1028

Explain dml and ddl?

1004

When is a declare statement required?

1146

What is error ora-12154: tns:could not resolve the connect identifier specified?

1084

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1022

How many types of cursors are available in pl/sql?

1112

Can I learn sql in a week?

1082

How do I run sql profiler?

1076

What are the different types of dbms?

1016

What is a constraint?

1029

How do you remove duplicates without using distinct in sql?

984