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 the use of <> sql?

930

Define join and name different types of joins?

957

What is join view in sql?

896

What is the maximum number of rows in sql table?

955

Which sorts rows in sql?

967

what is bcp? When is it used?

1046

What is not equal in sql?

1006

How to place comments in pl/sql?

1096

Is it possible for a table to have more than one foreign key?

976

What is sql not null constraint?

981

how do you know the version of your mysql server? : Sql dba

935

What is the difference between null value, zero, and blank space?

1137

What is the best sql course?

930

Is it possible to pass parameters to triggers?

1030

What are three advantages to using sql?

958