SQL:Finding Duplicates with SQL

By -
Do you want to find duplicates in a table.
Suppose you want to find all email addresses in a users table that exist more than once:

SELECT email,
COUNT(email) AS NumOftimes
FROM users
GROUP BY email
HAVING ( COUNT(email) > 1 )



you can see more information about removing duplicate rows from this microsoft article
How to remove duplicate rows from a table in SQL Server

Comments

Post a Comment

Popular posts from this blog

IrfanView : Simple Windows graphic viewer

By -
Image
IrfanView is a very fast, small, compact and innovative FREEWARE (for non-commercial use) graphic viewer for Windows 9x, ME, NT, 2000, XP, 2003 , 2008, Vista, Windows 7.  (click here for IrfanView EULA ) It is designed to be simple for beginners and powerful for professionals. IrfanView seeks to create unique, new and interesting features, unlike some other graphic viewers, whose whole "creativity" is based on feature cloning, stealing of ideas and whole dialogs from ACDSee and/or IrfanView! (for example: XnView has been stealing/cloning features and whole dialogs from IrfanView, for 10+ years). IrfanView was the first Windows graphic viewer WORLDWIDE with Multiple (animated) GIF support. One of the first graphic viewers WORLDWIDE with Multipage TIF support. The first graphic viewer WORLDWIDE with Multiple ICO support. Some IrfanView features : Many supported file formats (click here the list of formats ) Multi language support Thumbnail/previe
Read more

MySQL Cluster Overview

By -
Image
16.1. MySQL Cluster Overview MySQL Cluster is a technology that enables clustering of in-memory databases in a shared-nothing system. The shared-nothing architecture enables the system to work with very inexpensive hardware, and with a minimum of specific requirements for hardware or software. MySQL Cluster is designed not to have any single point of failure. In a shared-nothing system, each component is expected to have its own memory and disk, and the use of shared storage mechanisms such as network shares, network file systems, and SANs is not recommended or supported. MySQL Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (which stands for “ N etwork D ata B ase ”). In our documentation, the term NDB refers to the part of the setup that is specific to the storage engine, whereas “ MySQL Cluster ” refers to the combination of one or more MySQL servers with the NDB storage engine. A MySQL Cluster consists of a
Read more
By -
Grants privileges to MySQL user CREATE USER  'root'@'localhost' IDENTIFIED BY 'pass'; pass : enter your password Grant full rights GRANT ALL ON *.* TO 'root'@'localhost'; more info http://dev.mysql.com/doc/refman/5.1/en/grant.html
Read more