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 |
in which journalling which attributes are necessary
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
How do you find whether a job is a batch job or interactive?
how can i retrieve the field name from display file at run time? Devendra Singh Tomar
1.find most occurrences of a character. for exm: input:aaabbbbdddddyyy output: d 5 times how can i get that?
HOW DO YOU DISPLAY A DISPLAYFILE AT OTHER WORKSTATION? CAN WE MOVE A PHYSICAL FILE? WITHOUT MOVING A FILE?
1.Coding in cl to send an message? 2..What is turnover and use? What are the different levels?
What is the difference between inner join @ outer join
What is difference between bind by copy and bind by reference?
steps involved in debugging and types of debugging modes?
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?
How to check which are the pgms using 1 perticulate file.? I know there is many tool available for X-reference...but need to know is there any command available in the system...?