how do you count the duplicate records in a table
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 |
Post New Answer View All Answers
How do I write a sql query in pgadmin 4?
What is difference between my sql and sql?
What is assignment operator in pl sql?
what is acid property in database? : Sql dba
define sql delete statement ? : Sql dba
what is table? : Sql dba
What is use of trigger?
Explain the components of sql?
How to use sql statements in pl/sql?
Can we commit in trigger?
Explain correlated query work?
What is an emotional trigger?
What is recursive stored procedure?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is a temp table?