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

How to find out duplicate records in a table(Query)

Answer Posted / lakshmanlal

hi gud evening all, this is lakshmanlal.k.
suppose my table EMP having one column like ENAME in that i
am having 5 values like lakshman,lakshman,siva,rajesh,kiran
now i am writing query for duplicate records
select ename from EMP(tablename)
group by ename
having count(ename)>1

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the maximum no. of devices supported in SCS-1,2 and 3?

1901


In the 7 Stages of the SDLC (Planning, System Analysis, System Design, Development, Testing, Implementation, and Maintenance), what is the INPUT and OUTPUT of each stage?

858


Mention what are the categories of defects?

1039


What is functional system testing?

1127


How do you obtain the expected results for testing a search operation?

966


Explain metric?

1072


The Following Characterstics posses some XYZ company. * Uses formal standards and policies * Conducts software inspections * Has advanced configuration management and change control * Uses CASE tools * Has a software engineering process group * Gathers metrics on process and quality * Requires that developers have formal software engineering training * Practices continued process improvement Based on aboue , Tell me which CMM Level is the company..? 1. Level 1 - Initial 2. Level 2 - Repeatable 3. Level 3 - Defined 4. Level 4 - Managed 5. Level 5 - Optimizing

2189


What is quality circle?

1093


Explain basis path testing?

1124


What is difference between known regression testing and unknown regression testing?

1069


What is the main goal of defect prevention meeting?

1072


What is top-down strategy?

961


Mention what the basic components of defect report format are?

1007


you are a SQA lead on a project that uses an agile development environment, The lead developer has been instructed to write and initially-failing automated test case, then produce minimum amount of code to pass the test and finally refactor the new code to acceptable standards. based on above, Which type of SQA-focused SDLA is being used?

1728


Can any of u help me... How to use Security below listed testing tools 1. XSS Probe 2. SQL Power Injector 3. CAL9000 I have to do security testing using these tools.But I do not have any knowlwdge on this. I am trying to work using Help doc, but use, not able to follow Pls do needful

2097