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

What is a synonym? What are its various types?

1175

Can we write dml statement in function in oracle?

1126

What is a read only transaction in oracle?

1081

What is difference between truncate and delete?

1100

What is primefaces used for?

1098

how to handle exceptions in post production

1486

Explain oracle’s server parameter file.

1041

What is the data pump import utility?

1074

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2092

What are the parameters that we can pass through a stored procedure?

1118

How do we create privileges in oracle?

1103

Explain alias?

1193

What are dml statements in oracle?

1132

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3101

Is there an oracle sql query that aggregates multiple rows into one row?

1032