Need a sql query: retrieve all duplicate records in table?
Answer Posted / ssd
SELECT username, email, COUNT(*) FROM users
GROUP BY username, email HAVING COUNT(*) > 1
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is file identifier where we can use?
what do you mean by an input subfile, what are the keywords required?
is this a rpg channel?
Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?
how do I declare a minor?
give an eg of ACQ-(ACQUIRE),BIT OFF,BIT ON,DEALLOC,DUMP,FEOD,FORCE,MHHZO,MHLZO,MHLLZO,MLHZO,REL,RESET,TESTZ,TESTB,TESTN----GIVE SMALL EXAMPLE TO THE OPCODES...TO UNDERSTAND FUNCTIONING...........
what is an online rpg?
We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?
how does the rpg element work?
How to declare the pull button in AS/400..
How to write record if no field or the field are different in physical file in rpgle ?
If my rpg program has a date field, what extra care I have to take while compiling that rpg program? If the file is keyed and I have declared the file as well as key list properly in my program. Still am getting an error message like "chain/reade operation is not allowed" what may be the case?
How many program bind in one module....
what is data area and how it is used in rpg program ?
how do I play {insert rpg system here}?