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 conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

979

what is the difference between char_length and length? : Sql dba

1027

What does subquery mean in sql?

1035

What is synchronized subquery?

1144

What plvcmt and plvrb does in pl/sql?

1294

Where do we use pl sql?

982

How to run sql functions in pl/sql?

1041

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1045

Explain polymorphism in pl/sql.

1096

What is the process of debugging?

1049

What is oracle and pl sql?

1106

Which are the different types of indexes in sql?

1043

What is a dynamic query?

1009

What is the starting oracle error number? What is meant by forward declaration in functions?

972

how to drop an existing view in mysql? : Sql dba

1043