select * from A group by no having count(*)>1 ;

I have table-A(1,2,3,4,4,5,6,6,6,7).
how to get all duplicate values?what is sql query?

Question Posted / sudipta santra

5 Answers
8381 Views
Zensar, I also Faced
E-Mail Answers

Answer Posted / sudipta santra

select * from A group by no having count(*)>1 ;

Is This Answer Correct ?

7 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why should I use oracle database?

942

What is the difference between Delete, Truncate and Drop in Oracle?

1065

Explain the use of inctype option in exp command.

976

How to create a table index?

1060

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1368

What are the various constraints used in oracle?

991

What is where clause in oracle?

980

How to use regular expression in pattern match conditions in oracle?

975

What is meant by an index?

1058

Why use resource manager in Oracle?

1049

Explain user account with reference to oracle.

926

what is a Nested Loop join?

2039

What do you mean by merge in oracle?

937

What is oracle analytical function?

1029

What is a package ? What are the advantages of package ?

1033