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
11622 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

Explain sql data types?

1077

Where is pl sql used?

942

Can %notfound return null after a fetch?

1040

what is the difference between delete and truncate commands? : Sql dba

1044

Can you join views in sql?

939

Why is sql important?

1088

How do I find duplicates in the same column?

1059

What is the use of function in sql?

1069

what does the t-sql command ident_current does? : Transact sql

964

What does select top 1 do in sql?

1077

Does sql require a server?

994

What is numeric function sql?

1043

What is a temporal table?

916

Why we use triggers in mysql?

978

What is cascade in sql?

946