# Mysql – Finding the same value in a column and only returning rows without the same value

database-designMySQL

I have a query that i have to find the DiscountPercent that are the same and not show the rows with the same DiscountPercent. I have tryd this and it brings back the values that are the same

SELECT
ProductName,DiscountPercent
FROM
Products
WHERE
DiscountPercent in (SELECT DiscountPercent
FROM Products
GROUP BY DiscountPercent
HAVING COUNT(*) < 1)
ORDER BY
ProductName;


What i want to accomplish is to bring in the products that don't have the same discount percentage. I don't think i am doing this the right way.What is the correct way of doing this?

This is some data in the ProductName and in the DiscountPercentage

ProductName        DiscountPercent
Fender Precision     30.00
Fender Stractocaster 30.00
Gibson Les Paul      30.00
Gibson SG            52.00
Hofner Icon          25.00
Ludwig 5-piece       30.00
Rodriguez Cabelle    39.00
Tama 5-piece         15.00
Washburn D10         0.00
Yamaha FG700s        38.00


The Desired result that must use a subquery

ProductName       DiscountPercent
Fender Precision    30.00
Gibson SG           52.00
Hofner Icon         25.00
Rodrgiguez Cabelle  39.00
Tama 5-piece        15.00
Washiburn D10       0.00
Yamaha FG700s       38.00


SELECT MIN(ProductName), DiscountPercent

SELECT DiscountPercent,