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 use of stored procedures?

972

What is sql resultset?

929

What is the difference between microsoft access and sql?

958

Cite the differences between execution of triggers and stored procedures?

1026

How do I sort a table in sql?

983

What is the left table in sql?

910

What is the largest value that can be stored in a byte data field?

955

Do we need to rebuild index after truncate?

972

What is %s in sql?

970

What does stand for in sql?

915

How to Execute a Package in PL/SQL.?

1106

What are reports usually used for?

966

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

968

What is coalesce in sql?

970

How many aggregate functions are available there in sql?

928