I've got a table of data with 3 fields as follows:
SupplierID, ProductID, Price
1, 1, 1.50
2, 1, 2.50
3, 1, 3.50
1, 2, 1.20
Important point to note is that for each value of ProductID there are
What I want to do is the following:
1. Get a count of the number of unique ProductIDs for which there is
no SupplierIDs offering prices below some value. I thought this would
work, but it does not:
SELECT COUNT(*) FROM Inventory WHERE MIN(Price)>'1.49' GROUP BY
I get "invalid use of group function".
2. Get a ...