Write a Query to get Unique names of products without using DISTINCT keyword.

We can use GROUP BY for this purpose. It can print the distinct groups of PRODUCT NAME.

SELECT prod_name
FROM product
GROUP BY prod_name

Leave a Reply

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