select empno from emp group by empno having count(empno)>1; it is wor

How to display all the duplicate records from the oracle
Table?

Question Posted / raghunath

Answer Posted / raghunath

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

it is working.

Is This Answer Correct ?

10 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the functionalities of link partitioner?

972

What are the main features of datastage?

1205

What is the difference between orabulk and bcp stages?

966

How to reverse the string using SQL?

1425

Is possible to create skid in dim,fact tables?

2587

How many types of views are there in a datastage director?

1231

If you want to use the same piece of code in different jobs, how will you achieve it?

1094

Can you explain players in datastage?

1142

Describe the main features of datastage?

1036

What are the different options associated with dsjob command?

1370

which r the connectors used in san?

2142

How to read multiple files using a single datastage job if files have the same metadata?

1176

What is the project in datastage?

1046

What is the different type of jobs in datastage?

900

Explain Quality stage?

1087