Select statement

[Former Member]

Hi,

How can i get the maximum number of one field using select statement...

Thanks&regards,

Praveen

please reply me

[Former Member]

Hi,

Your question is not quiet clear, but to get the maximum of a field in a DB-table you can use SELECT MAX( <name of the field>).

Regards,

John

[Former Member]

Hi Praveen,

I didn't get u r question..cud u explain u r issue

clearly..

Regards

Ashok

[Former Member]

Hi all,

Thanks for your replies. I got the output as required.

Regards,

Praveen

Edited by: Praveen kumar Mannepalli on Jan 10, 2008 8:01 PM

[Former Member]

USe the aggregate Function MAX().

Eg:

Select Max ( Field1 ) from Tablename Into Table itab

WHere <condition>

Group By Fields..

awrd points if useful

Bhupal

[former_member313782]

Hi Praveen,

use aggregate fn max

select max( field ) from.........

U can try like this,

MAX (field): The maximum value of the field

eg.

SELECT MAX (field) INTO (W_MAX)

FROM table <table name>

ENDSELECT.

Hope you have understood.

Kindly reward points if useful,

Regards,

Jose