Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

in which journalling which attributes are necessary

2 Answers   CTS,


How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?

0 Answers  


How do you find whether a job is a batch job or interactive?

4 Answers  


how can i retrieve the field name from display file at run time? Devendra Singh Tomar

3 Answers  


1.find most occurrences of a character. for exm: input:aaabbbbdddddyyy output: d 5 times how can i get that?

14 Answers   HCL,


HOW DO YOU DISPLAY A DISPLAYFILE AT OTHER WORKSTATION? CAN WE MOVE A PHYSICAL FILE? WITHOUT MOVING A FILE?

2 Answers  


1.Coding in cl to send an message? 2..What is turnover and use? What are the different levels?

4 Answers   IBM,


What is the difference between inner join @ outer join

4 Answers  


What is difference between bind by copy and bind by reference?

0 Answers  


steps involved in debugging and types of debugging modes?

1 Answers  


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?

6 Answers   CSC,


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...?

4 Answers   IBM,


Categories