hi sir,

It is very good. but tell me more some idea to decreas cpu utilization..

HI FREINDS,

USING FOLLOWING QRY AS REFERENCE FOR YOUR QRY

SELECT max(item_rate),Grp_ID FROM item_mast

WHERE Grp_ID IN ('001') AND item_rate NOT IN (SELECT max(IM.item_rate) FROM item_mast IM

WHERE Grp_Id=im.Grp_ID GROUP...