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 does black-box testing mean at the unit, integration, and system levels?

0 Answers   TCS,

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

0 Answers  

What is exhaustive testing?

0 Answers  

What is brainstorming?

0 Answers  

What are the valuable steps to resolve issues while testing?

0 Answers  

Send me the interview questions

1 Answers  

I am new for software testing field and learned manual testing and testing tools and have knowledge in java,oracle,c++ and datawarehousing concepts.I need help for interview preparation.How can I start to explain my projects Do I need to tell them with examples?

1 Answers  

What is policy?

0 Answers  

What is maintenance testing?

0 Answers  

What is virtual address?

0 Answers  

I Want To Join Infrasoft Technologies,what is the Procedure To Join The Company?

0 Answers   Infrasoft,

How to write an implementation plan for our QA system with small budget, from scratch.

0 Answers