Interested to Buy Any Domain ? << Click Here >> for more details...
Need a sql query: retrieve all duplicate records in table?
- 1 Answers
- 2246 Views
- I also Faced
- E-Mail Answers
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
How can we know running job is batch or interactive?
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 difference between bind by copy and bind by reference?
can I touch the array during treatments?
how do I declare a table or array in rpg iv?
what are the key words you must use when using a subfile?
How to call one program from another program in RPG? please help me with the code
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
How Chain operation copies the record's data to the input buffer for the program?
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
What is the difference between copybooks and subprocedures in as400?
What is ment by record level identifier?
what is a rpg?
thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400
