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 are the types of subqueries?

768

How do you know if a relationship is 2nf?

689

What is the example of procedure?

678

How to rename a column in the output of sql query?

737

how can we destroy the cookie? : Sql dba

742

What programs use sql?

731

what is offset-fetch filter in tsql? : Transact sql

715

How do I install microsoft sql?

718

Which command is used to call a stored procedure?

713

how to do backup entire database? : Transact sql

884

How do I view stored procedures?

739

What are the different types of constraints?

742

What is number function in sql?

709

What is data modelling in sql?

712

how to show all tables with 'mysql'? : Sql dba

816