I'm looking for something other than DISTINCT because with distinct you would return $2.90, $4.78, $1.99. $6.22 with the given column below in a table (let's say table groceries).
SELECT DISTINCT price
Try this one
SELECT price FROM groceries GROUP BY price HAVING COUNT(*) = 1