topic Re: max in select statement in Application Development and Automation Discussions

max in select statement

Former Member — Wed, 20 Dec 2006 13:22:12 GMT

Hi,

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

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 — Wed, 20 Dec 2006 13:23:43 GMT

HI,

Try

   select max(empid) into v_empid
   frrom table_name.

Regards

Arun

Former Member — Wed, 20 Dec 2006 13:24:15 GMT

Solved

Former Member — Wed, 20 Dec 2006 13:25:21 GMT

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