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
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?
what is data area and how it is used in rpg program ?
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...?
what is kids-rpg?
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.
How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...
can any one help in hawkeye and turnover or any change management system plzzzzz or send the documents to my mail id :gvsp.as4@gmail.com
How to write record if no field or the field are different in physical file in rpgle ?
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
How many program bind in one module....
what is an online rpg?
what is the procedure and explain about real time scenario.
what is *place and *auto keyword in prtf ?plz explain
What is file identifier where we can use?
explain sflclr, sflend, sfldlt, and sflcsrrrn?