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 is tns service name?
How to check your oracle database 10g xe installation?
How to put more than 1000 values into an oracle in clause?
What is oracle open database communication (odbc)?
What are the different types of failures that occur in Oracle database?
What is a select query statement in oracle?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How to rename a tablespace in oracle?
How do we represent comments in oracle?
What is a nvl function? How can it be used?
What are the various oracle database objects?
State and explain about oracle instance?
How to create a new table in oracle?
Can we call procedure inside function in oracle?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.