lowest Price Fetching
I've a problem with Access Database. I want to fetch lowest price and its product name. I'm using a SQL Query like:
select pro_name, prorate from (select pro_name, sum(pro_rate) as prorate from mandatory group by pro_name, pro_rate
order by pro_rate) where rownum = 1
This Query is successfully running in oracle but in the access i am not getting the output I think Access does not support the ROWNUM keyword so can you help me here to take this query or any other way to fetch such a record.
Thanks for any suggestion.