I have table-A(1,2,3,4,4,5,6,6,6,7).
how to get all duplicate values?what is sql query?
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
What are the differences between primary key and unique key?
State and explain the different types of data models?
Is the After report trigger fired if the report execution fails ?
How to get a list of all user accounts in the database?
How to connect to a local oracle 10g xe server?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What are ddl statements in oracle?
What is oracle sid?
Can we convert a date to char in oracle and if so, what would be the syntax?
How will you identify oracle database software release?
What is tns service name?
What is blob datatype?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is an oracle database table?
how do u setup a replication site?