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

What is string join?

550

What is replication id?

518

How to convert comma separated string to array in pl/sql?

596

What is clustered index sql?

503

What is vector point function?

562

What is the requirement of self-join?

540

How many types of cursors are available in pl/sql?

586

Is it possible to sort a column using a column alias?

601

What is an intersect?

650

What are all the different normalizations?

587

Do we need commit after truncate?

610

Can we create a trigger on view?

487

Which one is better sql or oracle?

496

what are rollup and cube in t-sql? : Transact sql

657

What is sql query optimization?

541