Dba Doc

Monday, June 22, 2009

How to identify Duplicates in a table using SQL PLUS

How to identify Duplicates in a table using SQL PLUS 


SELECT COUNT(*), COLUMN_A, COLUMN_B
FROM TABLE_B
GROUP BY COLUMN_A, COLUMN_B
HAVING COUNT(*)>1;

Posted by Dba Doc at 3:48 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Labels

  • AIX (1)
  • AIX Commands (1)
  • DOS COMMANDS (1)
  • MS SQL Server Scripts (1)
  • ORA- Error Codes (1)
  • ORACLE DATABASE PROCEDURES (1)
  • ORACLE SCRIPTS (1)
  • PL/SQL Errors (1)
  • RMAN (1)
  • RMAN ERROR CODES (1)
  • WINDOWS UTILITIES (1)

Blog Archive

  • ►  2021 (1)
    • ►  January (1)
  • ►  2020 (2)
    • ►  December (2)
  • ►  2010 (2)
    • ►  March (2)
  • ▼  2009 (16)
    • ►  September (2)
    • ►  August (3)
    • ▼  June (8)
      • How to identify Duplicates in a table using SQL PLUS
      • ORA-01618
      • ORA-29707
      • Delete a Service in Windows using SC (Service Cont...
      • SQL Server Table Space Usage
      • SQL Server Scripts
      • AIX Commands
      • AIX OS Level
    • ►  May (2)
    • ►  April (1)
  • ►  2008 (27)
    • ►  July (5)
    • ►  June (4)
    • ►  May (5)
    • ►  April (1)
    • ►  March (12)
Awesome Inc. theme. Powered by Blogger.