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 |
How to improve in english
Could anyone share FAQs for Test Manager position.
What is service pack..what is the purpose of this..?This question was asked in an testing interview..that's why i posted this in this category..
1 Answers Infeneon Technologies,
What advantages would using an iSCSI Storage Area Network (SAN) give to your organization over using Direct Attached Storage (DAS) or a Fibre Channel SAN?
can anybody tell me the architecture for window based application and for the web based application for java as well as dotnet application(web based and for window based).its very very urgent pls
Mention what the difference between a 'defect' and a 'failure' in software testing is?
what is differnete between bug report@bugtracking
Define the notion of transaction and deadlock ?
What are the layers of FCOE Protocol?
words Mortal Combat, Street Fighter, Dead or Alive and Doom have in common?
what box testers shouldn't look inside the a. code b. design c. specification d. none of the above
What is the common risk that leads to project failure?