topic Re: Select statement in Application Development and Automation Discussions

Select statement

Former Member — Thu, 10 Jan 2008 10:48:49 GMT

Hi,

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

Thanks&regards,

Praveen

please reply me

Re: Select statement

Former Member — Thu, 10 Jan 2008 10:51:22 GMT

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

Re: Select statement

Former Member — Thu, 10 Jan 2008 10:52:21 GMT

Hi Praveen,

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

clearly..

Regards

Ashok

Re: Select statement

Former Member — Thu, 10 Jan 2008 10:52:48 GMT

USe the aggregate Function MAX().

Eg:

Select Max ( Field1 ) from Tablename Into Table itab

WHere <condition>

Group By Fields..

awrd points if useful

Bhupal

Re: Select statement

former_member313782 — Thu, 10 Jan 2008 10:57:43 GMT

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

Re: Select statement

Former Member — Thu, 10 Jan 2008 11:07:05 GMT

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