Interested to Buy Any Domain ? << Click Here >> for more details...
How to find out duplicate records in a table(Query)
- 6 Answers
- 13082 Views
- CybAge, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vishal
try this query
select name,count(*) from X1 (X1 being the table name)
group by name
having count(*)>1
| Is This Answer Correct ? | 12 Yes | 2 No |
Answer / madhav
select name,count(name) from mastertable group by name
having count(name)>1
instead of NAME use your own fields
Best of luck
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / santosh
we have to use the group by with having command to get the duplicate values. this query shall show the result of only the users have duplicate values in the employee table.
Syntex:
Select columnName From Table_name
Group By columnName
Having count (*) > 1
Example:
SELECT UserID FROM employee
GROUP BY userid
HAVING count( * ) > 1
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / deepika galankar
if table " stud " contains data :
studid name
1 xyz
2 pqr
3 per
1 xyz
then query is
select name ,count(name) from stud
group by name
having count(name)>1;
thank u .
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / 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 |
What is the difference between web application and desktop application in the scenario of testing?
What is control chart?
What do you think is the perfect test management system for test service vendors like me?
What is quality system?
I need to learn everything I can about Function, Non-Functional and Regression Testing. What is the best online resource?
What is “NOOB” related to Gaming
How u r managing the time constraints in completing the project?
Hi, Can nybody tel me the how much a Manual tester should know about Database and its connections with the web application?
How is an sql query executed in oracle 8?
What do you think would be a perfect testing tool for waterfall model?
what is the gendral format for test case?
What is a document version?
Automation Testing 
