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

6 Answers
17619 Views
I also Faced
E-Mail Answers

Answer Posted / eswar

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

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

List different type of expressions with the example.

928

how to shutdown mysql server? : Sql dba

1082

Why do we use sqlite?

956

Can we rollback delete command?

974

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4251

What is a dirty read sql?

1109

What is the use of partition by in sql?

976

How many sql statements are used? Define them.

1020

what is 'mysqlimport'? : Sql dba

1018

What is scalar data type in pl sql?

1054

What is trigger explain it?

997

Explain what is a database?

1073

How do I view a sql trace file?

1006

What are the 3 modes of parameter?

1145

How do you explain an index number?

1080