Hi everyone,
I want to write sql in access to get lowest price and product name.
for example, I have tblproduct(ProductID,ProductName,Price)
ProductID ProductName Price
001 A 10
002 B 20
003 C 7
I want to get result like this 003 C 7
I already tried this code: select productid,productname, min(price)
from tblproduct
group by prodcutid,productname
It didn't get only lowest price but it display all data.
Please help me....