check whether all the emp numbers are indeed unique.

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / lakshmimca85@yahoo.com

6 Answers
15387 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

check whether all the emp numbers are indeed unique...

Answer / nagendra

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

Is This Answer Correct ?

22 Yes

4 No

check whether all the emp numbers are indeed unique...

Answer / santhi kandasamy

In Oracle,

select empno from emp where empno is not null
group by empno
having count(*) >1;

if the above query does not return any rows then you can
consider, empno having unique values.

Is This Answer Correct ?

7 Yes

0 No

check whether all the emp numbers are indeed unique...

Answer / eswar

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

Is This Answer Correct ?

1 Yes

0 No

check whether all the emp numbers are indeed unique...

Answer / suresh somayajula

in rownum we will use < or <= operators only.

If any one knows this query pls send the answer.

Is This Answer Correct ?

0 Yes

1 No

check whether all the emp numbers are indeed unique...

Answer / biswajit rout

SELECT empno,count(*) FROM emp GROUP BY empno;

Is This Answer Correct ?

0 Yes

1 No

check whether all the emp numbers are indeed unique...

Answer / valli

select rowid from (
select emp_no, rownum() over (emp_no) as Rownum
from emp order_by emp_no,sal
) where rownum > 2

If this query returns no rows then we can say all the emp
numbers are indeed unique.

Regard,
Valli

Is This Answer Correct ?

0 Yes

5 No

Post New Answer