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 timestamp in mysql? : Sql dba

642

What is offset and limit in sql?

644

What is crud diagram?

597

What is pl sql code?

678

How to call shell script from pl sql procedure?

719

how to calculate the difference between two dates? : Sql dba

642

what is 'mysqld'? : Sql dba

625

What is recursive stored procedure?

701

How many types of privileges are available in sql?

849

What is sql not null constraint?

683

who introduced sql?

657

When are we going to use truncate and delete?

627

Can we insert data into view?

603

Is primary key always clustered index?

638

Does view store data in sql?

611