Least rate in 6 months bought item base on item name

[simhadrisai]

i have table called po it holds columns pono,supplierid ,itemname,docda te,itemdisc,rat e,discount,tota lamount
on different docdate with different supplierid and different rate same item is there in po table
when i give itemname in run time it has to give least rate of that item with docid and supplierid in last 6 months from as on date.

[Rabbit]

Use an aggregate query to return the min rate given an item name. You then take the result of that and join back to the table on the rate filtering for the item to get the rest of the information.