User login
Sponsored links
Recent blog posts
- PeopleSoft Object Type List
- PeopleSoft Data Integrity Error (124,85)
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
- How can we call Dynamic Calling section in Peoplesoft Application Engine program?
- How can we write multiple SQL Commands/Statements under one Action by using one function?
You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.
Duplicate row errors
- Login to post comments
Thu, 04/19/2012 - 5:43am
Hi,
How can v check for duplicate rows in a record?
Bookmark/Search this post with
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| how to send hyperlink with email in application engine program. | PeopleSoft Technical | 06/13/2013 - 12:55am |
| Saving records | PeopleSoft Technical | 06/04/2013 - 11:11am |
| can we alter a trigger in DB2 to add a new column | SQL & PL/SQL | 05/29/2013 - 1:31am |
| Required Peoplesoft HRMS Functional Training | PeopleSoft Functional | 05/07/2013 - 10:29pm |
SELECT col1, col2,col3,count(col3)--put the last column of duplicate combination in Count()
FROM table1
GROUP BY col1,col2,col3
HAVING COUNT(col3) >1
if database is oracle try this.
self join
select A.key1, A.key2... from TABLE A, TABLE B where A.key1= B.key1 and A.key2 = B.key2 ... and A.ROWID <> B.ROWID