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

Are sql database names case sensitive?

937

what is a record in a database ? : Sql dba

997

What is trigger in pl sql with examples?

982

What are the two types of cursors in pl sql?

1004

What is procedure explain with program?

952

What is the benefit of foreign key?

962

what is cross join? : Sql dba

941

How do you create a db file?

959

How do I view a table in sql?

954

What is pl sql code?

995

How can one get sql*loader to commit only at the end of the load file? : aql loader

1005

What is full form of rtm?

953

how to concatenate two character strings? : Sql dba

1033

What is offset in sql query?

1073

Why do we use subquery?

944