Hi everyone!

  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.

Deepak..

__________________
DPK..

hi there...

if it always the first row, why not

SELECT TOP 1 pro_name, etc....



HTH

Gonzalo

Thanks Gonzalo!

Now I done it.

Deepak..