•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 427,201 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,280 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser: Programming Forums
Views: 4277 | Replies: 4
![]() |
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,290
Reputation:
Rep Power: 4
Solved Threads: 83
It is better to start a different thread for a new question.
anyways try to use this sample query
anyways try to use this sample query
oracle Syntax (Toggle Plain Text)
DELETE FROM emp e WHERE rowid>(SELECT MIN(ROWID) FROM emp WHERE e.empno=empno)
Last edited by debasisdas : Feb 22nd, 2008 at 5:58 am.
Share your Knowledge.
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,290
Reputation:
Rep Power: 4
Solved Threads: 83
You can also use this sample query with a different logic
oracle Syntax (Toggle Plain Text)
DELETE FROM emp WHERE ROWID NOT IN(SELECT MAX(ROWID) FROM emp GROUP BY empno)
Share your Knowledge.
•
•
Join Date: Nov 2007
Location: � Jogja �
Posts: 2,585
Reputation:
Rep Power: 11
Solved Threads: 235
what a piece code
Never tried = Never Know
So, Please do something before post your thread.
* PM Asking will be ignored *
So, Please do something before post your thread.
* PM Asking will be ignored *
![]() |
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
- how to delete duplicate record in a table by using SQL query (MS SQL)
- SQL - questions . (MySQL)
- Design an SQL that will delete the MIN value in one field (Techies' Lounge)
- Php newsletter error (PHP)
- Giving records in MS Access unique numbers (MS Access and FileMaker Pro)
Other Threads in the Oracle Forum
- Previous Thread: i need help in my query
- Next Thread: Oracle Statistics



Linear Mode