mobileNavlogo
headerlogo

SQL Handling Duplicates

21 September, 2018

Ratings

Related Blogs

SQL Handling Duplicates Overview

There may be a situation when you have multiple duplicate records in a table. While fetching such records, it makes more sense to fetch only unique records instead of fetching duplicate records. The SQL DISTINCT keyword, which we already have discussed, is used in conjunction with SELECT statement to eliminate all the duplicate records and fetching only unique records. Syntax of Distinct Keyword The basic syntax of DISTINCT keyword to eliminate duplicate records is as follows: SELECT DISTINCT column1, column2,.....columnN FROM table_name WHERE [condition] Example: Consider CUSTOMERS table is having following records: +----+----------+-----+-----------+----------+ | ID | NAME     | AGE | ADDRESS    | SALARY   | +----+----------+-----+-----------+----------+ |  1 | Ramesh   |  32 | Ahmedabad |  2000.00 | |  2 | Khilan   |  25 | Delhi     |  1500.00 | |  3 | kaushik  |  23 | Kota      |  2000.00 | |  4 | Chaitali |  25 | Mumbai    |  6500.00 | |  5 | Hardik   |  27 | Bhopal    |  8500.00 | |  6 | Komal    |  22 | MP        |  4500.00 | |  7 | Muffy    |  24 | Indore    | 10000.00 | +----+----------+-----+-----------+----------+ First let us see how the following SELECT query returns duplicate salary records: SQL> SELECT SALARY FROM CUSTOMERS ORDER BY SALARY; This would produce following result where salary 2000 is coming twice which is a duplicate record from the original table. +----------+ | SALARY   | +----------+ |  1500.00 | |  2000.00 | |  2000.00 | |  4500.00 | |  6500.00 | |  8500.00 | | 10000.00 |

About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .