How to find out duplicate records in a table(Query)
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 different Between Black boxtesting and functional testing...
Explain dynamic testing?
If the client identified some bugs to whom did he reported?
hello frnz when we r testing cookies for security testing in that we have to check for deleting cookies my ques is do we have to delete from browser(google chrome m using) or from hard drive? reply soon thanx
What is system?
what is system testing?
Explain code inspection?
What is a 'walkthrough' in Software Testing?
Explain traceability matrix?
why we split testing into distinct stages?
If 12=4, 22=10, 32=21 then 42=__?
10 Answers EA Electronic Arts,
please suggest me some topics for research in software testing/software reliability......