SELECT COUNT(*) FROM TABLE A WHERE ROWID NOT IN (SELECT MAX(ROWID)

how do you count the duplicate records in a table

Question Posted / satheesh

Answer Posted / satheesh

SELECT COUNT(*)
FROM TABLE A
WHERE ROWID NOT IN (SELECT MAX(ROWID)
FROM TABLE B
WHERE A.COL1 = B.COL1);--UNIQUE COLUMN

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the difference between drop and truncate commands in sql?

1022

What will you get by the cursor attribute sql%found?

949

What is package in pl sql?

1001

How does sql store data?

892

Why truncate is used in sql?

984

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

965

How is use pl and sql?

1050

What trigger means?

967

What is nvarchar max in sql?

995

What does the hierarchical profiler does?

1048

How do I quit sql?

935

How do you explain an index?

1268

Why is a primary key important?

1025

Is oracle and sql same?

993

What are the advantages of pl sql?

1107