SQL>select * from a; A B ---- ------------------------- 1 Nam

What is the Query to print out the individual total number of
duplicate row in sql.

Question Posted / raveendran

5 Answers
11718 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / raveendran

SQL>select * from a;

A B
---- -------------------------
1 Name
ABC
BCA
fdhgjdshfj

3 Name
ABC
BCA
fdhgjdshfj

2 Name
ABC
BCA
fdhgjdshfj

4 Name
ABC
BCA
fdhgjdshfj

5 asd

A B
---- -------------------------
asd
asd
asdd

6 asd
asd

7 asd asd
8 asd asd

sql>select count(b),b from a group by b having count(b)>=1;

T(B) B
---- -------------------------
4 Name
ABC
BCA
fdhgjdshfj

1 asd
asd

1 asd
asd
asd
asdd

2 asd asd

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do you think about pl/sql?

1041

What is sql mysql pl sql oracle?

1077

Why commit is not used in triggers?

1047

what is a database transaction? : Sql dba

1190

What is sql and also describe types of sql statements?

1069

Can we use rowid as primary key?

992

Can we use threading in pl/sql?

1043

How do you go back in sql?

993

What are the datatypes available in pl/sql ?

1111

How do you declare a user-defined exception?

1030

What is the difference among union, minus and intersect?

1005

Explain the select statement in sql?

1117

What company owns postgresql?

1035

What is string join?

981

What is cost in sql execution plan?

991