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
Explain mdt?
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg
How to call one program from another program in RPG? please help me with the code
How can we override a file during runtime in rpg?
if there is a module object , how to find the program object for this module object.Assume the module object name and program object name is not same.
what is *place and *auto keyword in prtf ?plz explain
How Chain operation copies the record's data to the input buffer for the program?
what is the use of sflnxtchg?
How would display prime numbers using CL program?
How can we know running job is batch or interactive?
how can you display specific subfile page on the screen in unequal subfile?
1. What is bound-by-call and bound-by-reference? 2. Where and why is *Nomain used? 3. What are the difficulties faced by programmers when using service programs? 4. Explain the different ways of parsing and compiling XML in iSeries.
What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?
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?
what happens when sflsiz = sflpag? What are the advantages and disadvantages?