Answer / nagendra

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

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.

Answer / eswar

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

Answer / suresh somayajula

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

If any one knows this query pls send the answer.

Answer / biswajit rout

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

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 sql port 1433 encrypted?

0 Answers  

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

7 Answers   Cognizant,

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

0 Answers  

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

5 Answers   Doyensys, Infosys, Metric Stream,

What is a record in pl/sql?

0 Answers  

What is an Exception ? What are types of Exception ?

2 Answers  

how to delete an existing column in a table? : Sql dba

0 Answers  

What is sql character function?

0 Answers  

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

What is an Integrity Constraint?

4 Answers  

What does count (*) do in sql?

0 Answers  

How do I create a sql script?

0 Answers