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
8591 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

candidate key is subset of super key but not vice-verse explain

2070

How many file formats are supported to export data?

1220

What is a cursor in oracle?

1177

How to set up autotrace for a user account?

1060

How to create a temporary table in oracle?

1273

How are extents allocated to a segment?

1128

Explain the use of ignore option in imp command.

1038

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1087

Use of an integrity constraint is better to validate data. Explain

1043

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2314

how to join query for one source type is oracle another source type is sql server ?

2428

How to define default values for formal parameters?

1048

How to start your 10g xe server from command line?

1073

Describe the types of sub query?

1000

Will you be able to store pictures in the database?explain.

995