Systems Automation

A Blog of Automation and Administration Activities

Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Thursday, September 24, 2009

Find Duplicate records in Oracle

SELECT COL_TO_CHECK, COUNT(COL_TO_CHECK)
FROM TABLE_NAME
GROUP BY COL_TO_CHECK
HAVING COUNT(COL_TO_CHECK) > 1
Posted by ullas at 12:25 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: SQL
Older Posts Home
Subscribe to: Posts (Atom)

Search This Blog

Labels

  • Awk (4)
  • Bash (17)
  • Build Automation (2)
  • Database (1)
  • Docker (1)
  • Excel (2)
  • Java (11)
  • Jython (15)
  • Linux (70)
  • MySQL (1)
  • Perl (15)
  • PMP (1)
  • PostgreSQL (1)
  • Python (6)
  • Sed (3)
  • Solaris (9)
  • SQL (1)
  • Testing (1)
  • Weblogic (3)
  • Windows Automation (37)
  • WLST (12)
  • XML Automation (6)

Links

  • Google News

About Me

ullas
View my complete profile

Blog Archive

  • ▼  2017 (2)
    • ▼  September (2)
      • EMACS Basic
      • Docker Swarm
  • ►  2014 (1)
    • ►  September (1)
  • ►  2012 (1)
    • ►  December (1)
  • ►  2010 (43)
    • ►  June (9)
    • ►  May (12)
    • ►  April (11)
    • ►  March (9)
    • ►  February (1)
    • ►  January (1)
  • ►  2009 (113)
    • ►  December (15)
    • ►  November (9)
    • ►  October (4)
    • ►  September (7)
    • ►  August (40)
    • ►  July (21)
    • ►  May (3)
    • ►  April (1)
    • ►  February (13)
  • ►  2008 (1)
    • ►  March (1)
  • ►  2005 (4)
    • ►  March (4)
  • ►  2004 (27)
    • ►  December (27)
Ethereal theme. Powered by Blogger.