Answer / vishal

try this query

select name,count(*) from X1 (X1 being the table name)
group by name
having count(*)>1

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

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

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 .

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

Answer / sekhar

select records from table where count(record)>1

What is the difference between negative and positive testing?

0 Answers  

Where do you see yourself five years from now?

5 Answers   Hexaware, RBI,

Explain mutation testing?

0 Answers  

What is stochastic testing?

0 Answers  

Explain glass box testing?

0 Answers  

Explain software testing strategies?

0 Answers  

Which one of the following is used as a tool for tracking an SQA project? 1. Pareto chart 2. PERT chart 3. Run chart 4. Control chart 5. Cause and effect chart

1 Answers   eFunds,

What is random/monkey testing?

0 Answers  

If 12=4, 22=10, 32=21 then 42=__?

10 Answers   EA Electronic Arts,

Mention what the basic components of defect report format are?

0 Answers  

I am having 1.5 years of exp. in Manual testing.What I have to do now? Should I do ISTQB Certification or Perl/Shell Scripting Languages? OR Anything else.Please Guide me properly.

0 Answers  

What is the negative and positive testing?

0 Answers