Group Discounts available for 3+ students and Corporate Clients

SQL Handling Duplicates

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 |

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on SQL Handling Duplicates"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Support


    Please Enter Your Details and Query.
    Three + 6