Posted inMysql / Mysqli / php / Programming / Technology

sql select distinct multiple columns

Today, We want to share with you use distinct in sql.In this post we will show you sql distinct vs unique, hear for select distinct on one column, with multiple columns returned sql we will give you demo and example for implement.In this post, we will learn about sql unique count and use removes the duplicate values in sql with an example.

Using SQL SELECT DISTINCT COUNT ROWS Example

There are the Following The simple About sql removes the duplicate values on one column Full Information With Example and source code.

As I will cover this Post with live Working example to develop sql count(removes the duplicate values multiple columns), so the how to use removes the duplicate values in sql with join two tables is used for this example is following below.

Use the SQL DISTINCT keyword is used in conjunction as well as the MySQL SELECT query statement to eliminate all the duplicate or multiple rows and getting only unique rows.

SQL SELECT DISTINCT Statement

SELECT DISTINCT Syntax

SELECT DISTINCT column1, column2, ...
FROM database_table_name;

SELECT Example Without DISTINCT

SELECT Vender FROM Products;

SELECT DISTINCT Examples

SELECT DISTINCT Vender FROM Products;

// The following SQL statement lists the number of different (removes the duplicate values) Product Venders:

SELECT COUNT(DISTINCT Vender) FROM Products;

SELECT Count(*) AS DistinctCountries
FROM (SELECT DISTINCT Vender FROM Products);

SQL – Distinct Keyword

SQL> SELECT Vender FROM Products
   ORDER BY Vender;
SQL> SELECT DISTINCT Vender FROM Products
   ORDER BY Vender;

DISTINCT with null values example

SELECT DISTINCT
    price
FROM
    sales.products
ORDER BY
    price;

DISTINCT vs. GROUP BY

SELECT 
	p_desc, 
	p_calsfic, 
	price
FROM 
	sales.products
GROUP BY 
	p_desc, p_calsfic, price
ORDER BY
	p_desc, p_calsfic, price

uses the DISTINCT operator :

SELECT 
	DISTINCT 
       p_desc, 
       p_calsfic, 
       price
FROM 
	sales.products;

Example – With Single Expression

SELECT DISTINCT p_code
FROM products
WHERE product_id >= 50;

Example – With Multiple Expressions

SELECT DISTINCT p_name, p_code
FROM products
WHERE product_id >=50
ORDER BY p_code;

I hope you get an idea about use distinct in sql.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.

I am Jaydeep Gondaliya , a software engineer, the founder and the person running Pakainfo. I'm a full-stack developer, entrepreneur and owner of Pakainfo.com. I live in India and I love to write tutorials and tips that can help to other artisan, a Passionate Blogger, who love to share the informative content on PHP, JavaScript, jQuery, Laravel, CodeIgniter, VueJS, AngularJS and Bootstrap from the early stage.

Leave a Reply

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

We accept paid guest Posting on our Site : Guest Post Chat with Us On Skype