group
948062Sep 4 2012 — edited Sep 5 2012select approved_amount from target_aggregate where status='APPROVED' group by PA_REQUEST_ID;
SELECT req_amount from target_aggregate where level_id =(select min(level_id) from target_aggregate group by PA_REQUEST_ID);
can i use group by as i shown in above sql query