topic Re: Find highest value in Application Development and Automation Discussions

Find highest value

Former Member — Fri, 15 Feb 2008 09:35:50 GMT

from the table QAMV depending on the lot number PRUEFLOS

i have to fetch the highest value in SOLLSTPUMF

how to check this????

Regards

Nanda

Former Member — Fri, 15 Feb 2008 09:44:14 GMT

This ll do

select single max( SOLLSTPUMF ) 
from QAMV 
into v_SOLLSTPUMF 
where prueflos = p_prueflos.

Former Member — Fri, 15 Feb 2008 09:47:56 GMT

Hi Jose

thanks for your reply. How it will check for the highest value???

Depending on the lot number prueflos i have to fetch the highest value in the field SOLLSTPUMF.

For ex it is having the highest value as 10 then it has to show that value at that place

Regards

Nanda

Former Member — Fri, 15 Feb 2008 10:02:21 GMT

Plz reply me

Regards

Nanda

former_member282823 — Fri, 15 Feb 2008 10:22:48 GMT

Hi,

dont give any parameter there..just get the max using the query.

select max( SOLLSTPUMF )

from QAMV

into v_SOLLSTPUMF .

Hope this will be useful for u