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 are the different type of normalization? : Sql dba

1032

What does trigger mean in psychology?

966

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1105

Explain two easy sql optimizations.

1019

What are the types of keys?

998

How to pronounce postgresql?

1064

what is a trigger in mysql? Define different types of trigger. : Sql dba

1073

What does count (*) do in sql?

1017

What is sql server and ase?

1031

What is varchar sql?

1152

What is pl/sql table? Why it is used?

1040

How do I start sql from command line?

1027

What is %s in sql?

1038

Is sql a case sensitive language?

950

What is cold data?

966