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 |
Hi, Can any body tell me ur experience on this questions? Questions: 1.what is the use of SFLRCDNBR other than subfile page display? 2.Which of the following operation cannot be used in conjuction with a file coded as device type disk?
WHAT IS MENT BY RECORD LEVEL IDENTIFIER ? WHAT IS THE PURPOSE OF THIS?
I want my simple Green screen should refersh every 1 min ,How can I do it..? Please share the logic
2. Which of the following statement(s) explains the difference(s) between the /INCLUDE and ICOPY directives? a.) No difference, they function the same b.) ACOPY cannot be used as a conditional directive c.) IINCLUDE files cannot contain embedded SQL d.) Nesting /TNCLUDE directives is not allowed
how many variables can we declare in cl pgm?
can I touch the array during treatments?
Q1.How we can copy the data of file one session to another session? Q2.how we can execute a loop infinitely in AS/400 coding? Q3.In ALDON tool,multitask is posible on a perticular object by the user?
1.Where we declare Variables in RPG/400,RPGIV,RPGILE.? 2.When do we use D-spec and I-spec in real time ?.what is difference between them?
what is decimal data error? when it will come and how to achieve(rectify) this error please give me solution as well as code
If I have a file with 5 record and that file has 2 Key field and I want to read the unique record of the file then how can we achieve it?
Why we cannot call a service program? If I add a PEP can i call the service program?
HOW DO YOU DISPLAY A DISPLAYFILE AT OTHER WORKSTATION? CAN WE MOVE A PHYSICAL FILE? WITHOUT MOVING A FILE?