Interested to Buy Any Domain ? << Click Here >> for more details...
I have table-A(1,2,3,4,4,5,6,6,6,7).
how to get all duplicate values?what is sql query?
- 5 Answers
- 8444 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
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What is a package in oracle?
6. Display the client name and order date for all orders using the traditional method.
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is system tablespace?
Please explain oracle left join with an example?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is the difference between postgresql and oracle?
What are the data types in oracle?
What is the difference between a user and a schema in oracle?
What is blob data type in oracle?
How can we find out the current date and time in oracle?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
How to store only time; not date and time?
Can sub procedure/function be called recursively?
