max in select statement

[Former Member]

Hi,

I need to get the maximum number for a fiekld from a table...

like

I have a table as ZType

in that i have fields as

Empid Name

1 S

2 V

3 A

I need the maximum of the empid...

That is 3...

How to do this in select statement.

[Former Member]

HI,

Try

   select max(empid) into v_empid
   frrom table_name.

Regards

Arun

[Former Member]

Solved

[Former Member]

Hello,

U can do like.

Select * from ztable into itab.

sort itab by empid descending.

read table itab index 1.

or select max(empid) into v_empid

frrom ztable.

If useful reward.

Vasanth