How to get distinct column values in MySql?

Question

Comments

Eg: SELECT  DISTINCT agent_code,ord_amount  
FROM orders   
WHERE agent_code='A002';

---

Can we do without using distinct keywords

---

Yes Atindra we can but my point of view and performance wise Distinct is best approach here is the sample for that instead of Distinct keyword use GroupBy
SELECT t1.product, COUNT(*)
FROM MyTable AS t1
JOIN (SELECT product, consumer FROM MyTable GROUP BY product, consumer)
    AS t2 ON t1.product = t2.product
GROUP BY t1.product

---

Yes that what I was looking in the answer
Thanks for helping

Answer 1

EG: SELECT t1.product, COUNT(*)
FROM MyTable AS t1
JOIN (SELECT product, consumer FROM MyTable GROUP BY product, consumer)
AS t2 ON t1.product = t2.product
GROUP BY t1.product

Answer 2

HI.. You can try like this without using DISTINCT keyword

SELECT t1.product, COUNT(*) FROM TableName AS t1
JOIN(SELECT product, consumer FROM TableName GROUP BY product,consumer)
AS t2 ON t1.product = t2.product
GROUP BY t1.product