select fields in the max record

hi,

may i know how to select aggregate field1 and other fields in the same record where field1 is max?

this statement is incorrect. may i know what is the correct syntax?

thanks

select max( field1 ) field2 into (v_field1 , v_field2) from table where

fieldx = wa_inputrec-fieldx and

fieldy = wa_inputrec-fieldy.