Need a sql query: retrieve all duplicate records in table?



Need a sql query: retrieve all duplicate records in table?..

Answer / 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

More RPG400 Interview Questions

What is file identifier where we can use?

0 Answers  


How can we read a particular record from the database file which is not having DDS (Flat File). For example, there are 100 records in the flat file. How can we retrive 15th record in RPG/400 program (Without using CL)

6 Answers   CTS, IBM,


what is decimal data error? when it will come and how to achieve(rectify) this error please give me solution as well as code

2 Answers   IBM,


I want to declare the number of elements of an array dynamically in RPGLE ? Is it possible? If yes, then how do I do it ?

2 Answers  


I know whole thing ab't Arrays related to declaration..can anyone tell me what exactly use of array or anyone faced a situation where he found use of array must....

1 Answers  


1.what are the ARITHMETIC EXPRESSIONS IN CL PGM? 2.How to PASSING PARAMETER TO CL PGM?

1 Answers   NetCracker,


how do u find whether a record is locked or not??

4 Answers   CTS,


1.How you will find the program is batch or online in cl pgm? 2.How you will end the batch pgm when the job runs? write an logic? 3.In wich command the option *drop is used?

2 Answers   TCS,


Mr.Yallamanda Reddy P thanks for your answer sir,can we use test(D) opcode in RPG/400,if yes please help me by eloborating on that answer by writing a sample code for that sir

2 Answers   iGate,


What is the purpose of PUTOVR keyword?

2 Answers  


How to read alternative records in a pf by using rpg?

8 Answers   IBM,


what are the parameters of jobd?give in detail.&what are the parameters of subsystem...????

1 Answers   CTS,


Categories