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 |
How can we receive values from a called procedure in CL?
wat is the difference between dataarea and data queue?
5 Answers Airtel, Four soft, Shahi Exports,
in which journalling which attributes are necessary
How can we make use of SETLL operation in CL?
How to code Page up and Page down in RPG for Single page subfile without using ROLLUP/ROLLDOWN in DSPF ?
What is the purpose of Panel Groups?
What will happen if we r using seton lr after return or vice versa.
Write a program to display prime numbers between 1 to 100 using RPGLE.
1.How to read a subfile in out put mode? 2.what are the keywords used to share same file? 3.using composite key which rpg code used?
why subproc not run in dftactgrp?????/plz explain
What you have to do in the display file when you are using message subfile?
what do you mean by an input subfile, what are the keywords required?