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

How can we receive values from a called procedure in CL?

1 Answers   IBM, NTT Data,


wat is the difference between dataarea and data queue?

5 Answers   Airtel, Four soft, Shahi Exports,


in which journalling which attributes are necessary

2 Answers   CTS,


How can we make use of SETLL operation in CL?

11 Answers  


How to code Page up and Page down in RPG for Single page subfile without using ROLLUP/ROLLDOWN in DSPF ?

3 Answers   HCL,


What is the purpose of Panel Groups?

4 Answers  


What will happen if we r using seton lr after return or vice versa.

5 Answers  


Write a program to display prime numbers between 1 to 100 using RPGLE.

1 Answers  


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?

3 Answers   HSBC,


why subproc not run in dftactgrp?????/plz explain

2 Answers   CSC,


What you have to do in the display file when you are using message subfile?

1 Answers  


what do you mean by an input subfile, what are the keywords required?

0 Answers   IBM,


Categories