Find highest value

[Former Member]

Hi

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]

This ll do

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

[Former Member]

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]

Hi

Plz reply me

Regards

Nanda

[former_member282823]

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