Interested to Buy Any Domain ? << Click Here >> for more details...
Need a sql query: retrive all duplicate records in table
- 3 Answers
- 11170 Views
- I also Faced
- E-Mail Answers
Answer Posted / kusum
For duplicate records retrieval::::
Select * from employee a where rrn(employee) > (select
min(rrn(employee)) from employee b where a.empno = b.empno)
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?
during execution, an rpg/400 program automatically follows a sequence of operations for each record that is processed. The built-in program cycle includes the following logical steps.
What is the difference between iter and do?
Set on command is used for closed all opened files , initialize var and release resource , return cmd is used for return to calling program but my req. Is dnt close opened files and resource must released while doing transactions , how can i do this...?
are there any useful c runtime apis that I can call from rpg iv?
explain sflclr, sflend, sfldlt, and sflcsrrrn?
how do I play {insert rpg system here}?
how does the rpg element work?
how can I tell when to replace the array?
what are the key words you must use when using a subfile?
What is ment by record level identifier?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?
What is the difference between copybooks and subprocedures in as400?
Interviewer asked me write down DDS for load all subfile .can anybody write dds
