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 |
What is file identifier where we can use?
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)
what is decimal data error? when it will come and how to achieve(rectify) this error please give me solution as well as code
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 ?
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.what are the ARITHMETIC EXPRESSIONS IN CL PGM? 2.How to PASSING PARAMETER TO CL PGM?
how do u find whether a record is locked or not??
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?
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
What is the purpose of PUTOVR keyword?
How to read alternative records in a pf by using rpg?
what are the parameters of jobd?give in detail.&what are the parameters of subsystem...????