SELECT sal,rn FROM (SELECT ROW_NUMBER () OVER (PARTITION BY sal ORDER BY

I have table-A(1,2,3,4,4,5,6,6,6,7).
how to get all duplicate values?what is sql query?

Question Posted / nathan

5 Answers
8533 Views
Zensar, I also Faced
E-Mail Answers

Answer Posted / nathan

SELECT sal,rn
FROM (SELECT ROW_NUMBER () OVER (PARTITION BY sal ORDER BY
empno DESC) rn,
sal
FROM emp)
WHERE rn > 1;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can we find out the duplicate values in an oracle table?

1032

Is java required for oracle client?

972

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2002

What is difference between truncate and delete?

1018

Explain coalesce function?

1176

Give the different types of rollback segments.

1016

what is the difference between restoring and recovering?

998

What is meant by raw datatype?

1045

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1030

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2335

What is the usage of save points in oracle database?

948

Explain oracle left join with an example?

986

does the query needs a hint to access a materialized view?

1844

How to return top 5 rows in oracle?

1034

How to assign data of the deleted row to variables?

1056