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

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

Please Help Members By Posting Answers For Below Questions

Explain the use of tables option in exp command.

1051

What is a sub query and what are the different types of subqueries?

1069

How to call a sub procedure?

1034

What is the max number of columns in an oracle table?

928

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

915

Difference between oracle's plus (+) notation and ansi join notation?

1025

What do you know about normalization? Explain in detail?

879

what is normalisation?what are its uses?

2201

Can a formula column be obtained through a select statement ?

2262

defination of bitmap index

2043

What is raw datatype in oracle?

1049

How to insert a record into a table?

1018

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2259

How to synchronize 2 schema's objects?

2114

How to get execution path reports on query statements?

926