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 common risk that leads to project failure?

0 Answers  

What is test specification?

0 Answers  

what is port testing

1 Answers   Infosys,

generally what they ask in a client interview.regarding projects what they might ask?

2 Answers  

what is testing , why will be testing ,what is responsibilities of tester

3 Answers   Infosys, TCS,

What is technical review?

0 Answers  

hi i m priya i m a new commer to this,this is good life of every one.i m surching job now so,i want project detail for NET BANKING and HELTH CARE pls send me quickly.thanks for every body. i m waiting for...........

0 Answers  

How will you recognise if a case is a 'test case'?

0 Answers  

A man has Ten Horses and nine stables as shown here. [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] [ ] The man wants to fit Ten Horses into nine stables. How can he fit Ten horses into nine...

11 Answers   Infosys,

Explain debugging?

0 Answers  

What is the difference between test matrix and traceability matrix?

0 Answers  

What is Mainframe testing all about? What is testing methodology which applies to this kind of testing? Can anyone with the basic knowledge of mainframe system can apply for the Mainframe testing job requirement?

0 Answers